Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I need help. I am using this '##.#0%' to show XX.XX% format for my column. But when it becomes less than 1%, lets say 0.95% it should show me 0.95%. But its showing me 95%. Anyone
Hi:
Try this one instead '#.##0,00%' or '#.##0,00 %' to have a nice space if you can.
I use this cause I use spanish notation.
Hi,
Try this format '##0.00%'
It will work.
It works absolutely fine. But one thing, i need to represent Dot (.) with Comma (,) in percentage. How can this be possible?
Can't reproduce this here with 11.2 SR3:
=num(0.001,'##.#0%','.',',' )
in a text box shows 0.10%
go into the object properties. tab "numbers" there you can change it
Hi,
Try this, '#,##0.00'.
Hi,
Try this, '#,##0.00%'.
Hi:
Try this one instead '#.##0,00%' or '#.##0,00 %' to have a nice space if you can.
I use this cause I use spanish notation.
Couldn't get the desired output as 0,96%. Remember, I'm using it in Calculated Dimension, so there's no option for dimensions to change through object properties, only Expression have. Anyone again?
you can change it generally in the script. there are some SET variables. take a look at ThousandSep , DecimalSep