I have a simple report that reads a database table. One of the fields from the database is a INVOICE.STILLTOPAY field. Occasionally this field will leave a .01 or a -.01 value. The user wants to just display this as a .00 variance. How would you do this? Would you create a formula saying
if STILLTOPAY=.01 or -.01 then 0 else STILLTOPAY
or is there a more elegant way of handling?
Thanks!
if STILLTOPAY=.01 or -.01 then 0 else STILLTOPAY
or is there a more elegant way of handling?
Thanks!