Hello smarter people than I,
I hope that you are well today!
Does anyone know if there is a way that I could create an IF statement with a Table Calculation that applies rules to the lines and a different rule for the totals below the raw data?
Something like,
If measure = 1, 1,
if measure = 2, 2,
if istotal(measure)=yes, 42,
0)))
let’s say.
So that a result might look like:
| Row | Measure | Table Calculation |
|---|---|---|
| 1 | 1.00 | 1 |
| 2 | 2.00 | 2 |
| 3 | 1.00 | 1 |
| 4 | 1.00 | 1 |
| 5.00 | 42 |
Any idea if this is a possibility?
Thank you! Have a nice day 