Hi Morten,
Multiple options for having static values in the TARGIT client:
- You can use calculations to compare with static numbers. E.g. if you have one measure (m1) in your crosstab you can make a budget variance calculation like this: sum(d1, 0, m1) - 2000000.
- You can use a similar calculation within e.g. a color agent to color green if above budget: sum(d1, 0, m1) > 2000000.
- If you want to see a static number in a crosstab you can add it as e.g. a calculated column where the "syntax" is simply this: 2000000.
- If you want use a Gauge object (e.g. a speedometer) for realized/budget visualization, you can add a value to the gauge object "as a static goal".
As for the conditional values based on specific dimension values, you will have to make one calculated column like this:
if allcount(d1, d1:0, m1) = allcount(d1, d1:@"[1134077]", m1) then 1000000 else
if allcount(d1, d1:0, m1) = allcount(d1, d1:@"[1134078]", m1) then 2000000 else
if allcount(d1, d1:0, m1) = allcount(d1, d1:@"[1134079]", m1) then 3000000 else 0
Of course, you can add as many "if-then-else"s as you like in this formula.
BR / Ole
Edited by user Monday, April 14, 2014 9:36:36 PM(UTC)
| Reason: Not specified