Percentage calculation

(0) Share

Report

Posted on by Community Member

I asked this question a few weeks ago but did find an answer. I have a P&L that I in which I want to have a gross margin percentage to appear in the SAME columns just below the gross margin. This worked in Frx, but for some reason it just returns 0%. I tried changing calculation priority from row 1st, column 2nd, but that didn't work.

Total Gross Margin	TOT	PGM+SGM
	===
Product GM%	CAL	@PGM/@PREV	###0.00%;(###0.00%)
Services GM%	CAL	@SGM/@SREV	###0.00%;(###0.00%)
Overall GM%	CAL	@TGM/@TREV	###0.00%;(###0.00%)