Hyperion Planning Forms - How to sum selected columns?
Hello
I want to sum selected columns in my Hyperion Planning form (Planning 11.1.2.4 / Classic interface). So as shown in a simplified example below, I need to sum Col A and Col C, but not Col B.
| Col A | Col B | Col C | |
|---|---|---|---|
| Row 1 | 2 | 8 | 77 |
| Row 2 | 5 | 8 | 1 |
| Sum | 7 | 78 |
Adding a formula row saying sum(row[1]) gives me the following which is not what I want:
| Col A | Col B | Col C | |
|---|---|---|---|
| Row 1 | 2 | 8 | 77 |
| Row 2 | 5 | 8 | 1 |
| Sum | 7 | 16 | 78 |
Guidance much appreciated. I have found few practical documented examples.
Tagged:
1