Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to substract 2 times within set analysis. I calculated 2 times:
Only({<Status= {'START'}>}Time)
Only({<Status= {'Completed'}>}Time)
But Only({<Status= {'Completed'}>}Time) - Only({<Status= {'START'}>}Time) does not work.
I hope somebody can help me
@bartwelvaarts , your time field values are possible texts. Try to parse these values like:
Time(Only({<Status= {'Completed'}>} Time#(Time, 'hh:mm:ss')) - Only({<Status= {'START'}>} Time#(Time,'hh:mm:ss')))
'does not work' - is a very limited information. Try to share more information on it, like: how your output look like with that expression and how you expect it to be, how your data look like, etc.
What is the output you are getting??
This is my flat data
I use : Only({<Status= {'START'}>}Time) & Only({<Status= {'Completed'}>}Time) to get the records on the same row, like the image below.
Next, I want to calculate the time between Completed & START.
I tried :
Only({<Status= {'Completed'}>}Time) - Only({<Status= {'START'}>}Time)
And als tried:
column(2)- column(1)
But both statements result in a NULL value
@bartwelvaarts , your time field values are possible texts. Try to parse these values like:
Time(Only({<Status= {'Completed'}>} Time#(Time, 'hh:mm:ss')) - Only({<Status= {'START'}>} Time#(Time,'hh:mm:ss')))
Worked perfectly! thank you very much!