previous function

[Luvsql]

I have a formula:

if {table.field}=Previous({table.field}) then 0
else {@Amount}

It works great except the first value is always blank, even with the convert nulls to default. Is there any reason why the formula doesn't work if the previous value is null or doesn't exist?

 

[lbass]

Try:

if previousisnull({table.field}) then {@Amount} else
if {table.field} = Previous({table.field}) then 0
else {@Amount}

This will give you the amount value for the first record or on change of {table.field}. You could also use:

if onfirstrecord then {@Amount} else
if {table.field} = Previous({table.field}) then 0
else {@Amount}

-LB

 

[Luvsql]

Wicked, worked great thanks!