Number format not display correctly on Chart

[Anonymous]

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

[avkeep01]

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'),...)

[Anonymous]

Hi AM van Keep

Thank you.  I will try it out and let you know.

Kind regards

Nayan

[avinashelite]

check the formatting you have defined in the chart properties > Number tab > Make it expression default and check once

[Anonymous]

Hi AM van Kemp

I've tried your expression, but no change in the result.  Here is the expression below.

Kind regards

Nayan

[Anonymous]

Hi Avinash

The Number format is set to "Expression Default"

Kind regards

Nayan

[afsarshaikh]

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 .

[avinashelite]

could you share the sample app , will check and get back to you ?/

[Anonymous]

Hi Avinash

I'll see what i can do as it is sensitive data.  Maybe create one with scrambled data.

Kind regards

Nayan

[Anonymous]

Hi Afsar

Yep, i did notice that and i have removed the comma.

Kind regards

Nayan