Comparing two fields in Set Analysis

[Anonymous]

Hello,

Can anybody tell what is the syntax error in this expression:

=count({<_IN_TIME={'>ShiftStartGraceTime'}>} DISTINCT(%Date))

Regards,

Balraj

[PrashantSangle]

Hi,

Try this

=count({<_IN_TIME={">$(=ShiftStartGraceTime)"}>} DISTINCT(%Date))

Regards

[sujeetsingh]

=count({<_IN_TIME={'ShiftStartGraceTime'}>} DISTINCT %Date ) Try this

[anbu1984]

What is ShiftStartGraceTime? Field or Variable?

[AbhijitBansode]

If ShiftStartGraceTime is variable then reply by max dreamer will serve the purpose else below

Count ( { < _IN_TIME = {" > ShiftStartGraceTime "} > } DISTINCT %Date )

[Anonymous]

not working. Same result

[Anonymous]

Not Working

[Anonymous]

Both are two different fields, my dear

[sagarkharpude]

count(Distinct{<_IN_TIME={">$(=ShiftStartGraceTime)"}>} DISTINCT(%Date))

[AbhijitBansode]

please attach demo app with sample data.