I'm struggling to get the number format correct in a chart table. The number format works perfectly fine when paste the formula in a text box. I've checked the Number tab on the chart and this expression is set to "Expression Default".
Below is my expression and further below are results three of the vMeasure selected. (I've shown both values together, the blue being the number format in a text box).
vMeasure = 3
vMeasure = 4
Hi nayanlalla, maybe you should use a PICK function. Which works as follows,
PICK(<number>,<function 1>, <function 2>,<function n>)
the number is the part you want to use, so PICK(2,<function 1>, function 2>,<function n>) uses the second function. When using an IF statement, the expression will be calculated in total every time. In a pick function only the part choosen will be calculated.
PICK($(vMeasure),NUM($(vSpend(vYTD)),'# ##0'),NUM($(vSavings(vYTD)),'# ##0'),...)
Is that expression working? I believe there's an extra comma(,) at the last If condition.
Kindly try removing it and apply the changes with the Expression Default on the Number Tab and close the Parenthesis for every If condition .