Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi attached I have a chart showing cumulative sales and cos. I also want to display profit % cumulatively but it will only show the % for each month. If I change the expression to full accumulation it will then add up each months percentage which does not work for profit percentage.
Does anyone know how to fix this? If you could reattach with the solution it would really help.
Try this expression with no accumulation
=1 - (RangeSum(Above(Sum({<Year = {"$(=TodayYear)"}>} COS), 0, RowNo()))/RangeSum(Above(Sum({<Year = {"$(=TodayYear)"}>} sales), 0, RowNo())))
Try this expression with no accumulation
=1 - (RangeSum(Above(Sum({<Year = {"$(=TodayYear)"}>} COS), 0, RowNo()))/RangeSum(Above(Sum({<Year = {"$(=TodayYear)"}>} sales), 0, RowNo())))