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

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

On 07/09/11 04:26, John Mullen wrote:
> Hi Andreas,
>
> adding the .00 to the divisor seems to screw up the result of the ABS
> function
>
> i,e,  13 days overdue = 1 week when dividing by 7
>                                 = 1.86 weeks when dividing by 7.00
>
>
> regards
>
> John
>
> On 6 September 2011 16:58, Andreas Säger <villeroy@t-online.de> wrote:
>
>   
> > Dividing an integer by another integer returns an integer.
> > Try this one:
> >  ABS( DATEDIFF( 'dd', "RENT_PAYMENTS"."Date_Paid", CURDATE( ) )  /  7.00 )
> >
> > --
> > View this message in context:
> > http://nabble.documentfoundation.org/Calculated-fields-not-showing-decimal-places-in-BASE-query-tp3313752p3313940.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
> >
> >
> >     
>
>   

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