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

Steve Edmonds wrote:
> Hi.
> > From the original posters example, he has decimal places, just not
> trailing zeros. I think the calculation is correct just the display of
> the result needs formatting. I don't use Base (yet) but is the correct
> data type for currency DECIMAL. Can the field display format be set by
> right clicking the field in the form as in a form letter.
> steve
The DATEDIF function returns an integer, 7 is an integer. So there is no
decimal involved in the calculation and the result is an integer despite the
division. No formatting attribute will change an iteger number. Any currency
format will end with .00 if the formatted value is an integer one.

How about this one with the last brace shifted:
ABS( DATEDIFF( 'dd', "RENT_PAYMENTS"."Date_Paid", CURDATE( ) ) )  /  7.00  
(first get the absolute day difference, then divide by decimal 7.00)

--
View this message in context: 
http://nabble.documentfoundation.org/Calculated-fields-not-showing-decimal-places-in-BASE-query-tp3313752p3314620.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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