Variable for Number format in charts

[kkkumar82]

All,

Can we use a variable which contains a number format rather than the regular format we have.

For eg:

in a chart if we go to number tab - > Money

Can I use a variable like vNumberFormat which contains a format like $#,##;($#,##)

I tired but was not successful.

Any tricks ??

Attaching a sample

Thanks

Kiran

[sunny_talwar]

Not sure if you can alter the format using variable from Number's tab, but you can definitely use the Num() function with a variable:

[kkkumar82]

Thanks Sunny for your response but rewriting the expression once again using Num() is a burden for me because I have some complicated expressions.

Regards

Kiran kumar

[avinashelite]

As per my knowledge in the Number tab you cannot use, but try like this ...

Directly add the num() function in the expression tab and use the variable to set the format.