Column(X)/Column(Y) problem

[#1]

Hello,

I have a table chart with two expressions that are using the accumulated option (12 steps).

I want to add a third expression which is Column(2)/Column(1). Doing that, the value returned on each row are not the value I am looking for instead it displays something else. (This is not a rounding issue)

I just want to divide the two numbers that are listed in Column 1 and 2 correctly. Anyone have any idea?

[#2]

That doesn't seem to affect the individual row values though?

/Fredrik

[stephencredmond]

Hi,

I did a test on this and can replicate the problem. What it is doing is dividing the actual results rather than the accumulated results.

If you change your expressions to include the accumulations in them, then it works (well, it works for me):

RangeSum(Above(Sum(Unit),0,12))

RangeSum(Above((sum(calc_NetSales)-sum(calc_MarginFixedCostPart)-sum(calc_MarginVariableCostPart)),0,12))

Regards,

Stephen

[#4]

Thank you very much!

That solution is perfect for me.