Calulated Column - Remove Qty if Credit Amount

[M1EnterpriseTech]

If you have a report where you want the system to remove Quantity if the item is ( credit amount)

Create Column Called : Qty Sold

The create Calculated Column as follows:

Column Name: QtySol

Column Header: QTY Sold

Data Type: System.Decimal

Format: G

Formula:

If([Invoiced]<0,0,[Quantity])

This basically says if the Invoiced is less than zero, zero the Quantity.

Quantity Sold will be the column where you will see the Qty that does not include Credit Amounts.