Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

table subtotal expression problem

Status
Not open for further replies.
lewis777

lewis777

Technical User
Nov 26, 2008
2
GB
lewis777 (TechnicalUser) Nov 26, 2008
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

 
Status
Not open for further replies.

Similar threads

dawnanne
  • Question
Loop through rows in an SSRS table
Replies
0
Views
102
dawnanne
dawnanne
Quotheraven
  • Locked
  • Question
SSRS Expression for certification updates
Replies
0
Views
664
Quotheraven
Quotheraven
Priya Hari
  • Locked
  • Question
Row Grouping in Table of content
Replies
0
Views
666
Priya Hari
Priya Hari
leifoet
  • Locked
  • Question
SQL syntax problem
Replies
5
Views
721
MarkSweetland
MarkSweetland
BTrees
  • Locked
  • Question
Store URL in Database Table and use this in SSRS field expression
Replies
0
Views
239
BTrees
BTrees

Part and Inventory Search

Sponsor

Back
Top