Hello,

I want put text on column based on the particular calculated member which hold sum of three calculated members.

ex : I have three calculated member A,B and C which has numeric value in it. such as

A=0 ,B=10, C=5 and i have another calculated member (D) which holds Sum of A+B+C here it is 15

Now, I want to give color text like Green, Amber and Red based on the Number display in D.

If D >0 and D<10 then put text “Green”

If D>10 and D<20 then put text “Amber”

If D>20 and D<30 then put text “Red”

I tried with D = A+B+C

and when tried with “CASE” Statement like

Case

When

D>0 AND D<10

Then

‘Green’

Else

'My Code here"

End

It throws “Tuple contains more than one Measure Dimension…” error . Could anyone help me to resolve this issue.

Please let me know if more details required on this. Thanks in Advance.