Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Need help with the correct expression to calculate based on column types

I need help writing the expression to calculate (sum) a row:

I need:

If “Column Type” = “Sales/Invoice” [Current Trx Amount] - [Current Trx Amount] (if the “Column Type” is “Credit Memos”.

Here is what i currently have (It is a TRAIN wreck - I know!!!):

IFS( [Document Type] = “Sales / Invoices”,

[Current Trx Amount] - IFS( [Document Type] = “Credit Memos”, [Current Trx Amount])
)
)

Here is the table (example) showing the raw data i need to calculate:

Thanks

0 14 559
14 REPLIES 14
Top Labels in this Space