Skip to Content
Nov 26, 2019 at 09:02 PM

Datediff issue


Hi All,

Im really hoping someone can help me here.

I'm reporting on a date column within a table to capture the time difference between rows for each status change. I'm using the following formula Datediff('n',{AUDIT.CREATEDATE},Next({AUDIT.CREATEDATE})) which is working as expected but as the formula is within the details section it will continue down through the entire report when I need to be able to only report on the grouped data and for it to then reset back to zero after each grouped record. I have attached screenshots to hopefully detail what I have and where it is going wrong.