subtotal expression for a table problem

[lewis777]

Hi

I need some help constructing/modify the below expression:

=IIf(Sum(Fields!totalmoney.Value)>105, (Sum(Fields!totalmoney.Value)-105)*0.128, 0) as a sub total in a table.

this currently gives the below result.

total money NI
bob 200 12.16
ted 104 0
subtotal 304 25.47

which is obviously incorrect.



Can anybody help me with an expression that will give the correct result ie 12.16.


thanks

 

[gmmastros]

This forum is for Microsoft SQL Server. It appears as though your query is written in Microsoft Access. I encourage you to re-post your question in forum701.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom