topic Re: How to restrict to excatly 2 Decimal points in Script in QlikView

How to restrict to excatly 2 Decimal points in Script

psk180590 — Wed, 25 Nov 2020 16:16:04 GMT

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!!

tresB — Thu, 07 Jun 2018 07:26:18 GMT

Try like:

Num(

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

, '##.00')

psk180590 — Thu, 07 Jun 2018 07:36:36 GMT

This is the result.

shiveshsingh — Thu, 07 Jun 2018 09:46:17 GMT

You can use num function

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

ogautier62 — Thu, 07 Jun 2018 10:04:03 GMT

Hi,

try :

Round(your number*100)/100