Hi All,
I am trying to create a bar chart where value labels should show text where available, or sum of values where there is value. The values look like something this
| Client | MyValue |
| A | included |
| B | excluded |
| A | 300 |
| C | included |
| A | 100 |
| B | 200 |
In script I've defined them like this:
if(IsText("MyValue"), Dual("MyValue",0), Dual("MyValue"* "USD Rate","MyValue"* "USD Rate"))) as "MyValue (USD)"
In the bar chart I have number formatting set as 'Measure Expression'. The measure expression I've tried:
=sum([MyValue(USD)])
=dual(text([Sublimit2 (USD)]),sum(num([Sublimit2 (USD)])))
=alt(text([Sublimit2 (USD)]),sum(num([Sublimit2 (USD)])))
and few other combinations, but I either get only text or only values.
