Substract 2 times in set analysis

[bartwelvaarts]

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

[tresB]

'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.

[PrashantSangle]

What is the output you are getting??

[bartwelvaarts]

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

[tresB · Accepted solution]

@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')))

[bartwelvaarts]

Worked perfectly! thank you very much!