Skip to Content
0
Former Member
Dec 06, 2013 at 05:12 PM

Using Previous with Variable/Formula

27 Views

I have one formula (formula1) that does some calculations and works well. I need to implement a second formula, which would be based on the value in formula1. I want formula2 to look something like this:

IIf {fieldA.Value} = Previous{fieldA.Value}, IIf(formula1.Value <> Previous(formula1.value), formula1.Value, ""),"")

Each time I try that I get an error highlighting Previous(formula1.Value), saying "This field has no previous or next value".

I've tried to default the formula1 value if its the first record, I've moved the formulas around to different sections, but I can't seem to get rid of that error.

Is there a way to get around this?

Any help is appreciated!