Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be like this:
If([DETAIL LEVEL] = 8, Sum(Amount), Sum(TOTAL <[BUSINESS UNIT], [OBJECT ACCOUNT]> Amount))
May be like this:
If([DETAIL LEVEL] = 8, Sum(Amount), Sum(TOTAL <[BUSINESS UNIT], [OBJECT ACCOUNT]> Amount))
I love you. It is indeed, Sunny T.
I thank you immensly.