Calculate total amount

[#1]

Hello, everyone.

I have the following table:

- DETAIL LEVEL 8 accounts have values in the table. Because of that, I can SUM(Amount) and get the desired amount (100, 150, 50...).

- DETAIL LEVEL 7 accounts DO NOT have values in the table. For these, what I want to do is to get the total from the sum of its level 8 accounts. For instance, for the first row, 2641.51111 = 2641.51111.1 + 2641.51111.2 + 2641.51111.3 = 100 + 150 + 50 = 300. Thus, I would like the first row to totalize 300. In the very same way I would want 2641.51112 to sum 200 + 800 = 1000.

Can this be achieved?

Thank you very much.

[sunny_talwar · Accepted solution]

May be like this:

If([DETAIL LEVEL] = 8, Sum(Amount), Sum(TOTAL <[BUSINESS UNIT], [OBJECT ACCOUNT]> Amount))

[#3]

I love you. It is indeed, Sunny T.

I thank you immensly.

[sunny_talwar]