topic Re: Help with rounding in script in QlikView

Help with rounding in script

Anonymous — Fri, 08 Dec 2017 20:12:32 GMT

I’ve attempted to do the following functions within the script and nothing seems to be working to remove the trailing numbers and round to the nearest cent.

Num([Posted Base Amount], ‘#,##0.00’)

Num#([Posted Base Amount], ‘#,##0.00’)

Round([Posted Base Amount], .01)

Ceil([Posted Base Amount], .01)

Floor([Posted Base Amount], .01)

Round(([Posted Base Amount] * 100) / 100

Left(([Posted Base Amount], Index(([Posted Base Amount], ‘.’)+2)

Has anyone seen anything like this before?

Round([Posted Base Amount], .01) works as an expression on the front end, but was wondering if there was anything in the back end that would fix the number throughout the application.

Re: Help with rounding in script

Anonymous — Fri, 08 Dec 2017 20:13:02 GMT

The data source ( People soft)

Re: Help with rounding in script

Anonymous — Fri, 08 Dec 2017 20:52:48 GMT

attached is the QVD

Re: Help with rounding in script

m_woolf — Fri, 08 Dec 2017 21:04:54 GMT

When I load your qvd, the numbers are all rounded to the nearest cent.

Re: Help with rounding in script

johnca — Fri, 08 Dec 2017 21:18:24 GMT

Indeed...the data in your qvd is only 2 decimal places...

Re: Help with rounding in script

Anonymous — Mon, 11 Dec 2017 14:14:11 GMT

Thank you for your response. let me check that and get back to you