Calulated Column - Remove Qty if Credit Amount

Calulated Column - Remove Qty if Credit Amount

Postby M1EnterpriseTech » 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.
Enterprise Support Specialist
M1EnterpriseTech
50 Club: Regular Contributor
50 Club: Regular Contributor
 
Posts: 80
Joined: Wed Aug 24, 2016 9:22 am

Return to Enterprise: Reports

Who is online

Users browsing this forum: No registered users and 1 guest