Calulated Column - Remove Qty if Credit Amount

Post Reply
M1EnterpriseTech
100 Club: Active Contributor
100 Club: Active Contributor
Posts: 171
Joined: Wed Aug 24, 2016 9:22 am

Calulated Column - Remove Qty if Credit Amount

Post by 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.
Enterprise Support Specialist
Post Reply

Return to “Enterprise: Reports”