Created attachment 129903 [details] Open the query. Have a look at the fields, which should show absolute numbers. Open the attached document. Open the query. There are numeric and decimal fields of the Firebird 3.0-database. To every field is asked for ABS("Fieldname"). The function works right, if the field-length is 10 or 11. Could be for all values greater than 9. The function ignores the decimal places for field-length less than 10. There are reported hundredfold values instead.
Confirmed. Arch Linux 64-bit, KDE Plasma 5 Version: 5.4.0.0.alpha0+ Build ID: fc0d4e6bc43d5f982452df07930f5ecf5927ad22 CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on December 31st 2016
Have tested this again: SELECT ABS(-23.45) FROM "Table" gives 2345 SELECT ABS(CAST(-23.45 AS NUMERIC(10,2))) FROM "Table" gives 23.45 You have to change the fieldtype and switch the length to min. 10 and the function will give the right value. Tested with Version: 5.4.0.0.alpha0+ Build ID: d9cfbabc7fe13752daf02e2a8cfa38c72a30fb29 CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-01-22_23:06:33 Locale: de-DE (de_DE.UTF-8); Calc: group
Works now with fix of https://bugs.documentfoundation.org/show_bug.cgi?id=105101