Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I am trying to use Max function along with timestamp function for calculation of measures, but getting an error in expression.
My expression is:-
Interval(
sum({<[reto]={'Correctly created'}>}
Timestamp(Timestamp#([edited date time],'YYYYMMDD hh:mm:ss'),'YYYYMMDD hh:mm:ss')
-
Timestamp(Timestamp#([detail end date time],'YYYYMMDD hh:mm:ss'),'YYYYMMDD hh:mm:ss')
)
,'hh')*24
Please suggest.
Can you check if the error goes away if you use this expression
=Sum({<[reto] = {'Correctly created'}>} (TimeStamp#([edited date time], 'YYYYMMDD hh:mm:ss') - TimeStamp#([detail end date time], 'YYYYMMDD hh:mm:ss'))) * 24