Rounding in caculated field

Let me just start with a :banghead:



I'm trying to get a query to perform a calculation and round the results.



The fields that I am running the calculation and am trying to round are Data Type Number, properties Field size Single and decimal places Auto.



I have tried the built in function described in Allen Browne's site to no avail.

http://ift.tt/1yFVicg



I have tried rounding the individual fields and then adding result.

I have also tried rounding the result (as attached).



Any thoughts?

Attached Images

Query example.png (25.5 KB)

Rounding in caculated field