What is the formula to get Amount from Transaction line using Main Line= True?
We are creating a saved search to for a custom sales KPI. We are able to retrieve Gross Sales, Net Sales, Tax, Refund & Shipping amounts with the following formulas: What we are unable to retrieve is the Discount Amount. We are using a GL account to record the discounts through a sales item labeled "Generic_Discount" which…