[libreoffice-users] Calculated fields not showing decimal places in BASE query

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: users+help@global.libreoffice.org
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