Hi can somebody help me on how to achieve this in Matrix table?
Budget Actual
Revenue $8,191,470.00 $4,250,333.54
Direct Cost of Sales $2,268,245.00 $1,517,080.61
Gross Margin $5,923,225.00 $2,733,252.93
Gross Margin % 72.30% 64.31%
Indirect Cost of Sales $0.00 $284,135.37
Net Sales Margin $5,923,225.00 $2,449,117.56
Net Sales Margin % 72.30% 57.62%
given values are: revenue, direct cost of sales, Indirect Cost of Sales
calculated values:
gross margin = revenue-direct cost of sales
grosss margin % = gross margin / revenue
net sales margin = gross margin - Indirect Cost of Sales
net sales margin % = net sales margin / revenue
How to insert this formula in a matrix cell to be able to acheive this calculated values?
Help would be greatly appreciated!