Hello, i am wondering if it is possible to define some kind of "conditional" numeric field within the NL-SUM Function. So what i mean is, that when i calculate a sum of the Value Entry Table JET REPORTS should some up the field "Amount" if a certain Flag is FALSE and "Discount Amount" if the flag is true.
I know i could be doing this by simple adding those two functions together, but i wanted to know if there is a more elegant way of doing this.
The Statement would look like this
=NL("Sum";"Value Entry";"Sales Amount (Actual)" OR "Discount Amount" ;"Posting Date";"Flag";"True/False")
Thanks in advance for your support! Best regards!