Return to FileMaker.com
Report - Calculate if field name = RETURN
I have a report that I have sorted by SalesID
If the field called SalesID contains the word "RETURN" I want that total to subtract from the grand total.
How do I do that... Can you help
In this case, you cannot directly sum the Invoice amount shipped field. Instead, define a calculation field as:
If ( SalesID = "RETURN" ; -1 ; 1 ) * Invoice amount shipped
And define your summary field to sum this calculation field instead of Invoice amount shipped.
Retrieving data ...