topic Re: Rounding Financial data in QlikView

Rounding Financial data

schivet — Thu, 13 Dec 2012 15:14:03 GMT

Hi,

Sometime you have financial data with more than two digits after the coma .... yes this is happening in my company.

If you want to round it to two digit, easy, just use the fonction:

Round ([Amount],0.01)

But you might have to cancel this financial data, yes you can..

In this case you might have a problem because the rounding will be do this way:

This is mathematique but not compatible with my need.

The only solution I found was this one:

if (Amount>0 , round(Amount,0.01), -round(-Amount,0.01)) as Amount

Stéphane

shree909 — Thu, 13 Dec 2012 15:30:40 GMT

Hi can u try this

replace

(round([Amount+]

,0.01),',',.)

After using this in the expression , on the number tab of the chart use expression as default..

this will work..

schivet — Thu, 13 Dec 2012 15:48:48 GMT

Hello,

No sorry your solution is not working:

shree909 — Thu, 13 Dec 2012 15:54:24 GMT

Hi i tried for the first expression and its showing up right values which it must be..

Did u change the number format to expression default.....????????

schivet — Thu, 13 Dec 2012 16:02:35 GMT

Can't see the print screens...

But I confirm that it's not working with [Amount-] (last column)

shree909 — Thu, 13 Dec 2012 16:08:23 GMT

schivet — Thu, 13 Dec 2012 16:18:39 GMT

Good try but replace(Ceil([Amount+],0.01) will not work fro the last value:

it should be 11691.68 and not 11691.69

if (Amount>0 , round(Amount,0.01), -round(-Amount,0.01)) as Amount is the solution