A value which exceeds 24:00 does not show

[helen_pip]

Hello

I have attached a QVW which shows data from an Inline view statement

The table at the front end shows the longest wait for MonthYear and YTD

However I know for a fact that the longest wait was actually 51 hours or 3105 minutes, but the way I currently have my expression in the table set up is to show the 24 hour clock.

I require help so that the table shows the longest wait even when the wait has exceeded 24:00

Can anyone help me achieve this?

[Gysbert_Wassenaar · Accepted solution]

Replace the time function with the interval function.

if (Level3_Month='95TH CENTILE',interval(Fractile({<Inline_Monthly_DataSource={ 'ED', 'EYE', 'MIU'} >} Inline_Monthly_Data_A,0.95)/1440,'hh:mm'),

...etc

[helen_pip]

Thank you so much

You have no idea how long I have spent tracking back to see where my data was corrupt....Clearly it was a lack of knowledge all along

Thanks

Helen