calculating difference from total in previous row

[kwj1027]

I am calculating the number of seconds since midnight to a date/time in a row.

I need to subtract the previous row entry from the current row to determine the amount of time (seconds) between the two rows.

Hopefully this is descriptive enough to describe the needed solution.

Regards

 

[poujor]

Hey,

Are you looking for something like:

if PreviousIsNull({Table.DateField}) then 0 else
datediff('s', Previous({Table.DateField}),{Table.DateField})


Poul

 

[kwj1027]

When I try the formula:

if PreviousIsNull({F57041.Q1TDTE}) then 0 else
datediff('s', Previous({{F57041.Q1TDTE}}),{{F57041.Q1TDTE}})


I get an error on the Previous field name as not being known?

regards

 

[BobSuruncle]

If this is an exact copy/paste, then you've got extra sets of French Braces (affectionately known as 'squigglies') around your field names.
Should be:

if PreviousIsNull({F57041.Q1TDTE}) then 0 else
    datediff('s', Previous({F57041.Q1TDTE}),{F57041.Q1TDTE})

Bob Suruncle

 

[kwj1027]

Amazing how a typo can mess one up! That seems to do exactly what I need.

Thank you for your assistance!

Regards~ Kevin