Table Sub total problem

Question

Post reply

Table Sub total problem

simon.lewis-796464

SSC Enthusiast

Points: 134
More actions
December 1, 2008 at 6:28 am

#196445

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, because it is translating it as 304-105*0.128. When, I actually want it, to sum to the result of the expresssion for each
Can anybody help me with an expression that will give the correct result ie 12.16.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 1

You generally need to do the calculation in your SQL or SP to get this calculation to work.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 2

Here's a long shot if you'd like to try it:

SUM(IIF(Fields!totalmoney.Value>105,Fields!totalmoney.Value-105,0))*0.128

Cheers

ChrisM

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

vicky-954852 SSC Enthusiast Points: 192 More actions · Answer 3

your expression works, this is the same, this should be in the footer of the group

=Iif(Sum(Fields!NetWeight.Value)>25000,(Sum(Fields!NetWeight.Value)-500)*.128,0)

simon.lewis-796464 SSC Enthusiast Points: 134 More actions · Answer 4

simon.lewis-796464

SSC Enthusiast

Points: 134

December 22, 2008 at 10:39 am

#916258

thanks for your help