Hi Guys, I am trying to create a report that shows the amount of rent overdue per tenant.
I have a field in a table which holds the weekly rate (a decimal field ). I am working out the number of weeks overdue by using the following formula ABS( DATEDIFF( 'dd', "RENT_PAYMENTS"."Date_Paid", CURDATE( ) ) / 7 ) and then multiplying by the weekly rate to get the amount overdue but the result never shows the trailing zeros. i,e, 155.50 always shows up as 155.5 I have tried prefixing the formula with CAST (formula) AS DECIMAL (6,2) Any ideas where I am going wrong Thanks John -- Cheapest mobile tariffs - GUARANTEED <http://www.discoverhow.co.uk/> "I train people to make money" <http://www.makemoney.discoverhow.co.uk/> "Action always beats inaction" - Robert T. Kiyosaki -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
