Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The data source ( People soft)
attached is the QVD
When I load your qvd, the numbers are all rounded to the nearest cent.
Indeed...the data in your qvd is only 2 decimal places...
Thank you for your response. let me check that and get back to you