Formula using FirstRecord and previous not working on first record

[themich]

I'm trying to get this formula to return "OK" for the firstrecord of the report and "DUP" if the subsequent records match the previous.

Here's where I'm at currently:

if ({@Check or Deposit ID}) = previous ({@Check or Deposit ID})
and ({@firstrecord}) = false
then "DUP"
else "OK"

However, it's not returning "OK" for the first record, it acutally returns a blank. I checked the field w/the firstrecord formula and it returns "true".

I don't know where to go from here.

 

[briangriffin]

You can use the recordnumber function to automatically plug in a value for the first record without writing an additional formula:

if recordnumber = 1 then "OK"
else
if {@Check or Deposit ID} = previous ({@Check or Deposit ID})
then "DUP"
else "OK"

 

[hilfy]

Or you could change the order of your if statement to something like this:

If not OnFirstRecord and {@Check or Deposit ID} = previous ({@Check or Deposit ID})
then "DUP"
else "OK"

You need the check for "First Record" to come BEFORE the check for Previous.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.