3 Replies Latest reply on Feb 25, 2015 8:41 AM by Vladimir Kostochka

# Round up issue ------

Hi,

I need small help, I am using below formula to display the positive and negative and percentage sign and also I need to round up the
number to one decimal. But the logic is not working if I make to round up for
2decimal or 3decimal its working but not for 1decimal.

Please find the above attached .twbx file for example.

If (sum([Market ? % ])) > 0 then "+" + Str(round((sum([Market ? % ])),1))+"%" else str(round((sum([Market% ])),1)) +"%"end

Thanks in Advance

Regards

Bhujang

• ###### 1. Re: Round up issue ------

You can do all that in the number formatting for Market %... just use

+#,##0.0"%";-#,##0.0"%"

as your formatting and it will keep it as a number and have 1 decimal place with a + or - at the front and a % at the end

• ###### 2. Re: Round up issue ------

Hi Robin,

Thanks a lot this solution is super, you made my work very easy.

Thanks&Regards

Bhujang

• ###### 3. Re: Round up issue ------

Hi Robin,

You can do all that in the number formatting for Market %... just use

+#,##0.0"%";-#,##0.0"%"

Is it in the expression or in the format section?