Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to convert these amounts to money by choosing 'Money' in Number tab in chart properties. Only some of the amounts are getting converted to money while the rest are not. I realized that the numbers having a 'comma' are the ones not getting converted to money. How do I solve this? Please Help.
It looked that you have a mix of numeric- and string-values in your dimension. In this case you need to make sure that all your values are numeric - this could be done in script by using num#(yourvalue, 'YourFormat') maybe within an if-loop to catch the differences of all their values.
- Marcus
Double check the formats of your number separators at the beginning of your script:
SET ThousandSep=',';
SET DecimalSep='.';
If your numbers are parsed correctly, all values should be right aligned in a list box by default.
It looked that you have a mix of numeric- and string-values in your dimension. In this case you need to make sure that all your values are numeric - this could be done in script by using num#(yourvalue, 'YourFormat') maybe within an if-loop to catch the differences of all their values.
- Marcus
Hi Chandni, I think that this happens because some numbers are strings.
So, first of all, convert the strings to numbers and then apply the money format.
To convert strings to number apply this function:
num(Num#([YOUR_VALUE],'###,###.####','.',','),'###,###.##')
I hope that it help you,
Regards,
Agustín
Thank You!
Thank You!