How to restrict to excatly 2 Decimal points in Script

[psk180590]

Hello All,

When i use the below expression in my script

Round((Sum(Total1)/Sum(Total2))*100,0.01)

I get results as in the below screenshot

Some values only have 1 decimal point, some don't have decimal point at all and few have more then 2 decimals.

What i would like to have is to restrict all the values to 2 decimal points.

Ex: -9,80

      -9,41

      -5,00

     .......

TIA!!

[tresesco]

Try like:

Num(

Round((Sum(Total1)/Sum(Total2))*100,0.01)

, '##.00')

[psk180590]

This is the result.

[shiveshsingh]

You can use num function

=num(Your Field,'###.00')

[ogautier62]

Hi,

try :

Round(your number*100)/100