Wednesday, March 28, 2012

Running Value

I currently have a report that salesmen gets a negitve or plus points on the sales that he/she makes. I need to keep a running total of these points. In addition I need this total to never to get over 10 points but if I need the points to minus from 10 if they get a negitive points on a sale.

Example:

Account 1: 4 points Running total: 4

Account 2: 4 points Running total: 8

Account 3: 4 points Running total: 10

Account 4: -2 points Running Total: 8

I have tried Iif statement but I don't know how to keep the value at 10. I also need to have the final value to show in a group footer.

Thanks for any help.

RunningValue(Fields!Cost.Value, Sum, Nothing)

check books on line for more info about RunningValue

sql

No comments:

Post a Comment