Define conditional Numeric Value for SUM Function

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!


Please sign in to leave a comment.