Using variable with if condition in textandImage chart

[Neha121]

Hi All,

     I am using some variables in the text and Image chart function as below. the first one is working fine as its a measure however the second variable has if condition that returns text. How do I use this variable so that the return value of vL_phy_avg is available in the text. I want $66.81 instead of 0. 

I have one more variable  var1= IF(F1>F2,"greater","less") want to incorporate this variable in the text.

[mpc]

Hi, 

Maye by forcing the calculation result using $(=vMyVar) ? 

Kind regards

[Neha121]

doesnt work

[anat]

You should have aggregate function to display CRA_Average.

Try like num(only(CRA_Average), '$0') 

[Neha121 · Accepted solution]

ended up doing like this