topic Re: converstion in QlikView

converstion

Thu, 10 Sep 2015 10:29:03 GMT

i want to display 99.996817129 to 99.99 in text object how to achieve this?

Re: converstion

marcus_sommer — Thu, 10 Sep 2015 10:31:02 GMT

Try: floor(Number, 0.01)

- Marcus

Re: converstion

gautik92 — Thu, 10 Sep 2015 10:33:11 GMT

=Num(value,0.00)

Re: converstion

sasiparupudi1 — Thu, 10 Sep 2015 10:41:20 GMT

=floor(99.996817129,0.01)

Re: converstion

qlikmsg4u — Thu, 10 Sep 2015 10:58:50 GMT

=floor(99.996817129,0.01)

Re: converstion

Anonymous — Thu, 10 Sep 2015 11:07:13 GMT

Hi Nilanjan, for text boxes it is helpful to use the num function. The above solutions are correct but if you want to make sure you always format the number correctly you can wrap it in the num function as follows:-

=num(floor(99.996817129,0.01),'# ##0.00')

You can then use any number format for the way you want to display the number.

Re: converstion

jonathandienst — Thu, 10 Sep 2015 11:08:14 GMT

99.996817129 rounded to 2 decimal places will round to 100.00, not 99.99

If 99.99 is what you want you will need to explain how you came to that number - it is not just rounded.