Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I'm pretty much sure that this is because "accumulate".
See what happens if you do not use it.
(If it's the case - I don't have a solution at this time.)
Hi,
sounds quite strange - can you please post an example of your file?
/Peter
What are the expressions in these two columns?
The first one is:
=
sum(Unit)
The second one is:
=(
sum(calc_NetSales)-sum(calc_MarginFixedCostPart)-sum(calc_MarginVariableCostPart))
Both is set to Accumulate 12 Steps back.
Thank you so much for your help!
Did you try to replace the expression by Expression 2 / Expression1 ?
Is it better or not ?
It gives me the same result, so no difference.
I'm pretty much sure that this is because "accumulate".
See what happens if you do not use it.
(If it's the case - I don't have a solution at this time.)
Ok. I'll guess I have to use another way to accumulate the first two columns instead.
Hello ,
If you are using the straight table then go into the Expressions tab on the chart properties and from the total mode select the expression total the default will be sum of rows and it should work.
Let me know how it goes
Talha