Find Error in this expression

[#1]

COUNT({<time((IN1-SHIFTSTARTTIME),'hh:mm:ss'){'<00:10:00'}>}PAYCODE)

IN1 ->field

SHIFTSTARTTIME ->Field

Paycode ->Field

hint:- {'<00:10:00'}

[tresesco]

Set ananlysis is used where you can compare a script generated field value. Actually, nothing is right in your expression. You should have written it 'Find What is Right ....' . Please read set analysis from help.

[#3]

=Count({<IN1={">$(=SHIFTSTARTTIME)"},time((IN1-SHIFTSTARTTIME),'hh:mm:ss')={"<$(=00:10:00)"}>}PAYCODE)

please I need help in this expresssion in Bar chart, how to apply this in an expression

error  is coming in {"<$(=00:10:00)"}>} on this { . Please help

[PrashantSangle]

Hi,

I am not what you are looking for

But looking at your expression I thing you are comparing

Time Interval Between IN1 and SHIFTSTARTTIME which is less than 10:00 Mins.

So try like this,

=Count({<IN1={">$(=SHIFTSTARTTIME)"},Interval(IN1,SHIFTSTARTTIME,'hh:mm:ss')={"<$(=00:10:00)"}>}PAYCODE)

Regards,

[swuehl]

=count( if( (IN1-SHIFTSTARTTIME) < maketime(0,10), PAYCODE))

[ToniKautto]

This question look very much like two other threads you have posted. What makes this any different from the previous posts?

I need help with this expression

need help with this expression

Have you considered the implementation approach I have already suggested in need help with this expression ?