peskywinnets
Registered User.
- Local time
- Today, 15:39
- Joined
- Feb 4, 2014
- Messages
- 576
I'm going Radio GaGa here - what am I missing? ...sum () issue
I have a field on a report called LineCostExVAT & is calculated like this...
=Round([UnitCost]*[Qty]/1.2,2) ......(it's essentially showing the rounded down price of the goods with VAT removed)
...this bit works fine, for example if the UnitCost is £9.99, the value of LineCostExVAT shows £8.32
All good so far
BUT, on the same report, I also have a Sub Total field which is essentially the sum of all LineCostExVAT fields on the report , it's calculated like this...
=Sum([LineCostExVAT])
but it shows £8.33 .....so my problem is, the sum () is not summing correctly!!!! (i.e. it's showing £8.33 vs £8.32)
What am I missing?!!!!
here's a screen shot (orange box is the one showing the sub total incorrectly)...
I have a field on a report called LineCostExVAT & is calculated like this...
=Round([UnitCost]*[Qty]/1.2,2) ......(it's essentially showing the rounded down price of the goods with VAT removed)
...this bit works fine, for example if the UnitCost is £9.99, the value of LineCostExVAT shows £8.32
All good so far
BUT, on the same report, I also have a Sub Total field which is essentially the sum of all LineCostExVAT fields on the report , it's calculated like this...
=Sum([LineCostExVAT])
but it shows £8.33 .....so my problem is, the sum () is not summing correctly!!!! (i.e. it's showing £8.33 vs £8.32)
What am I missing?!!!!
here's a screen shot (orange box is the one showing the sub total incorrectly)...
Last edited: