Ask Your Question

Format calculated field in Base query

asked 2019-01-08 20:59:29 +0100

updated 2019-01-08 21:09:45 +0100

I have a decimal field in a query. Let's say 100.00. Then in a calculated field I multiply mentioned decimal field with let's say 1.3. Then that calculated field shows 130000 as a result. Why is that not 130.00? Or 130.000, if you like? In the corresponding field in a form it seems impossible to get 130.00 (format is with 2 decimals).

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-01-08 21:38:08 +0100

Ratslinger gravatar image


Your question can be answered if you are using Firebird embedded as the database. See this post -> When Appending a price the value is shifted.

If you are not using this, please supply basic information such as OS, specific LO version used & which database is being used.

edit flag offensive delete link more


I am indeed using Firebird. So it is a known bug. I will change database and see what happens. Many thanks.

armadillonicaragua gravatar imagearmadillonicaragua ( 2019-01-08 21:46:16 +0100 )edit

You're right. In HSQLDB it works as I would expect, Hopefully they will fix that bug in Firebird soon. Thanks again.

armadillonicaragua gravatar imagearmadillonicaragua ( 2019-01-08 21:50:32 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-08 20:59:29 +0100

Seen: 20 times

Last updated: Jan 08