Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey
what will be the expression to calculate margin percentage for 'total sales' and 'total cost'?
i need help with the expression.
i have used variables like
margin = 'vCm'
total cost price = ' vCcost '
total sales price = ' vCs'
so here i would like to calculate the margin percentage using the above variables>>what would be the expression to calculate??
thanks
Percentage are expressions that reflects the ratio of two values
So you have to divide one value by another, what are the values of the variables above?
vCm = sum( {<Year={'$(vCy)'}>}LineSalesAmount)-sum ({<Year={'$(vCy)'}>}CostOfGoodsSold)
vCcost = sum( {<Year={'$(vCy)'}>}CostOfGoodsSold)
vCs = sum( {<Year={'$(vCy)'}>}LineSalesAmount)
% = num(vCcost / vCs, '#,##0.00%')
error in expression
Would you mind sharing a sample of your data