Could some inform me as to how this report calculate profitability %
The calculation doesn't make sense and I can neither view it nor edit it nor back into it?
Date
Votes
3 comments
-
Jet Reports Historic Posts Well , I can finally see the calc but it still makes no sense. The calculation is a MARKUP % not a PROFIT %.
Still trying to Modify it but with Express can I? -
Jet Reports Historic Posts michaelcarrcpa,
It would appear that there is an incorrect calculation in this report. Attached is the revised report.
This report pulls Item Ledger Entry records into a table on the Report tab. An Excel pivot table is created using this table.
Calculated fields have been added to the Excel pivot table. These can be found and modified from the PivotTable Tools>Analyze ribbon.
Here are the pivot table field names and associated calculations:
Sales Amount:= Sales Amount (Actual) + Sales Amount (Expected)
Cost Amount:= Cost Amount (Actual) + Cost Amount (Expected) ***this is represented as a negative number
Profit Amount:= Sales Amount + Cost Amount
Profit%:= =IF('Sales Amount'=0,99999.99,('Profit Amount'/'Sales Amount'))
The previous Profit% calculation was:
Profit%:= =IF('Cost Amount'=0,99999.99,-('Profit Amount'/'Cost Amount'))
Let me know if you need any further clarification.
KRD -
Jet Reports Historic Posts Thank you.
Please sign in to leave a comment.