5 Replies Latest reply on Jun 19, 2018 3:36 PM by Shinichiro Murakami

Need help with calculation (adding two columns)

Hi Everyone,

I am stuck at a table calculation. Could anyone please take a look and help me out??

Given:

A Brokered/Direct filter (containing values Brokered,Direct)

1. If we select Brokered then it must display OpTarget Total Members Brkd

2.If we select Direct then it must display OpTarget Total Members Dct

3.If we select both(Brokered,Direct) then it must display the sum of OpTarget Total Members Brkd + OpTarget Total Members Dct

My calculation is as follows:

The problem is that the first two conditions displays data properly. Whereas the third condition subtracts the values instead of adding it.

1. Condition 1 (Brokered)

2.Condition 2(Direct)

3. Condition 3

Thanks,

Krish.

Attached workbook.

• 1. Re: Need help with calculation (adding two columns)

Calculation:

• 2. Re: Need help with calculation (adding two columns)

Hi Krishna

Not exactly sure, but does this help?

Thanks,

Shin

1 of 1 people found this helpful
• 3. Re: Need help with calculation (adding two columns)

Thanks Shin.

Just for my understanding I want to know that why does it not take direct addition?

Why do we have to workaround using LODs?

• 4. Re: Need help with calculation (adding two columns)

And Shin,

One more doubt??

How can we display the same when we select both the regions???

It must display the value of NCA + SCA.

I know that we have to use similar LODs but it's confusing.

• 5. Re: Need help with calculation (adding two columns)

HI Krishna

I just followed your example's guidance and I am still not sure about your final goal.

You are summing up the number after aggregating with "Avg" when you use normal calc, that shows simple average of both.

1st step: calculate avg of XXX at level AAA = CCC

2nd step calculate sum of CCC of each calendar range

Probably not necessarily to use LOD, but as described above, you are trying to make nested aggregation and LOD or table calc is anyways needed.

Thanks,

Shin