Hello lachass,

you are not providing sufficient detail to enable others to help you,

this post is obviously related to your previous topic '[Solved] How to calculate with a calculated field?' posted to this forum on Wed Feb 11, 2015 4:56 pm.

based on the previous topic i will assume that we have 5 fields:-

'CUSTOMER' varchar, 'AMOUNT' decimal, 'TAX' decimal, 'DAYS' integer, & 'ADVANCE' decimal.

I further assume that the question is “i use report builder. my query contains the above fields. how can i show the sum total for ('AMOUNT' + 'TAX') * 'DAYS' – 'ADVANCE'?”

the answer is YOU NEED TO DEFINE A FUNCTION.

this post shows how:

https://forum.openoffice.org/en/forum/viewtopic.php?p=210650#p210650follow the steps 1 to 12 with these exceptions.

2. our function needs to access the entire record set so we create it under 'Report'

6. Name = SumCalculatedField.

7. Formula = [SumCalculatedField]+([AMOUNT]+[TAX])*[DAYS]-[ADVANCE].

8. Initial value = ([AMOUNT]+[TAX])*[DAYS]-[ADVANCE].

9. Drag out a text box in the report footer.

12. Function = [SumCalculatedField].

I hope this helps. it may not be exactly what you wanted but should point you in the right direction.

open office 4.1.7 & LibreOffice 6.3.2 using HSQL 1.8.0.10 (Embedded) and HSQL 2.5.0 (Split) on Windows 10