I need to add a summary section to my invoice report with the value of the invoice from the previous year (if there is one).

I plan on storing the batch number for the previous years invoices in the invoice optional fields.

Here’s my formula to get the batch number called: @lastYearBatch

If ({ARIBHO.OPTFIELD} = "LASTFINALBATCH")

THEN {ARIBHO.VALUE}

Else ""

How do I select "ARIBH"."AMTINVCTOT" where "ARIBH"."CNTBTCH" equals @lastYearBatch ?