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?

[prieper]

Hi,

sounds quite strange - can you please post an example of your file?

/Peter

[#3]

I have a hard time recreating the problem with fake data and I rather not upload our GL.

Here is a picture to explain the problem further though:

I want the third column to say 23.5 for March, not 25.4

The expression just look like:

=column(2)/column(1)

[Anonymous]

What are the expressions in these two columns?

[#5]

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!

[#6]

Did you try to replace the expression by Expression 2 / Expression1 ?

Is it better or not ?

[#7]

It gives me the same result, so no difference.

[Anonymous · Accepted solution]

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.)

[#9]

Ok. I'll guess I have to use another way to accumulate the first two columns instead.

[#10]

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