Calulated Column - Remove Qty if Credit Amount
Posted: Tue Nov 07, 2017 1:36 pm
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.
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.