Monday, March 19, 2012

Got it to work....well partially

Hello everyone, I had a previous issue with if...then....etc statement, but I got it to work, so thats a good thing. The only problem is that it works only when i have a single line displaying, if its more than 1, it dont work any ideas why?

My report is table, broken into 2 groups, one by department, then by last name. My thought is the Sum(Fields!AMT_EARNED.Value) still giving me issues.....but I dont know....

=iif(((Fields!SumHRS.Value * 7.5) > Sum(Fields!AMT_EARNED.Value)),((Fields!SumHRS.Value * 7.5) - Sum(Fields!AMT_EARNED.Value)), 0)

Abner

p.s here is a picture of it.

http://i200.photobucket.com/albums/aa195/abz_26/Gotittowork.partially.jpg?t=1186176038

Nevermind........got it

|||tubular?

that's like so awesome dude

No comments:

Post a Comment