if condition between two time stamps

[#1]

Hi Experts,

i need to do an if condition between two times

Accesstime, Clearingtime. these are not in the timestamp format.

My condition is if (Accesstime - Clearingtime) is less than 30 minutes, then count the distinct salesproducts by year.

i m trying the below expression

IF(Time(Accesstime ,'hh:mm:ss')-Time(Clearingtime,'hh:mm:ss') <=('00:30:00'),

count(DISTINCT ProductNumber))

This expression is working fine if my dimension is ProductNumber.

but i want to calculate this by year, by month,.. it is not working with my calendar dimensions

Please help me to correct my expression

[sunny_talwar · Accepted solution]

You can try this:

Count(DISTINCT If(Time(Accesstime ,'hh:mm:ss')-Time(Clearingtime,'hh:mm:ss') <=('00:30:00'), ProductNumber))

[Anil_Babu_Samineni]

Try this too

IF(Time(Interval(Accesstime - Clearingtime),'hh:mm:ss') <=('00:30:00'),

count(DISTINCT ProductNumber))

[#4]

thank you so much sunny