Description |
Check out the row created in demo
[http://irelyserver1.com/i21Demo/i21/#/FRD/ReportBuilder/?action=edit&filters%5B0%5D%5Bcolumn%5D=intReportId&filters%5B0%5D%5Bvalue%5D=1%7C%5E%7C]
see that in the row you need some flexability in calculations
Note if you are working on units it is a little different
the total lines need to be added rather than devided becuase the sums are not valid for units.
if you sell 200 items
you have cost for 200 items
so you do not have margin on 400 items only 200 and you are subtracting cost from revenue
| |dollars|units|cost per unit|
|Sales|1000|200|5|
|Cost|600|200|3|
|Margin|400| |2|
| | | | |
!pastedImage_d42590_0.png!
|