Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
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).
Thank you.
Kind regards
Nayan
vMeasure =1
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'),...)
Hi AM van Keep
Thank you. I will try it out and let you know.
Kind regards
Nayan
check the formatting you have defined in the chart properties > Number tab > Make it expression default and check once
Hi AM van Kemp
I've tried your expression, but no change in the result. Here is the expression below.
Kind regards
Nayan
Hi Avinash
The Number format is set to "Expression Default"
Kind regards
Nayan
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 .
could you share the sample app , will check and get back to you ?/
Hi Avinash
I'll see what i can do as it is sensitive data. Maybe create one with scrambled data.
Kind regards
Nayan
Hi Afsar
Yep, i did notice that and i have removed the comma.
Kind regards
Nayan