from if to set analysis statement

[#1]

i have used this statement in straight table please , help me to convert this in set analysis

=if(SHIFTSTARTTIME<IN1 and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')>='00:10:00' and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')<'00:20:00','Yes','No')

SHIFTSTARTTIME is the starting time of a shift of a employee

IN1 is the in-time of a employee

by this statement i have successfully showed in front of employees name that if he is late by more than 10 min but  less than 20 min than show yes in that column

please help me to convert this statement into set analysis

[tresesco]

Set analysis is used where you directly can compare with a field. But here in your expression, you have portion like: time((IN1-SHIFTSTARTTIME),'hh:mm:ss')>='00:10:00' which is not really comparison with a single field. Therefore, the entire expression could not be converted to set analysis; it would be mix of set and if I guess.

[its_anandrjs]

For your If expression to the SET expression use variables because there is multiple calculations and it is very hard for converting to SET may be find the combination of If and SET

Let vTimDiff = time((IN1-SHIFTSTARTTIME),'hh:mm:ss');

for your expression

=if(SHIFTSTARTTIME<IN1 and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')>='00:10:00' and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')<'00:20:00','Yes','No')

[SergeyMak]

navneet_nav

Probably it's not good idea to ask same questions. I think you you can just edit previous one

if statement into set analysis

[#5]

how to put greater than symbol ">" in set analysis

count({<shiftstarttime={'<'(=in1) }>} Employee)

please convert above in correct set analysis

i want to show if (shiftstarttime<in1, count(employee)) in set

[rajat2392]

count({<shiftstarttime={"<$(=in1)" }>} Employee)

[tresesco]

in1 is another field right? Then try:

=count({<shiftstarttime={"=shiftstarttime>in1" }>} Employee)

[its_anandrjs]

Write like

count({<shiftstarttime={'<$(=in1)' }>} Employee)

[#9]

thanks