I am using CR 2013. My Goal is to isolate for any records where a formula was reset based on a running total calc. I wanted to apply a formula that said 'when value in previous row is greater than value in current row, exclude, else include. Below in bold is the record I am trying to isolate for:
EeID #RTotal Formula
1234 1,851.34 1,851.34
1234 1,924.54 1,924.54
1234 1,998.49 1,998.49
1234 2,071.59 2,071.59
1234 2,132.69 52.69 Display this record
I've tried the following formula:
If previous({@Formula}) > {@Formula} then "Exclude" which gives the following error message: "This field has no previous or next value".
Any other suggestions on how to isolate for the reset record would be great. Thanks!
