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!

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

How to get a total after using the switch statement?

Status
Not open for further replies.

spiego

MIS
Aug 16, 2004
80
US
I have a cell in my report that has the following statement
Code:
Switch(Sum(Fields!Baskets.Value) >= 1 and Sum(Fields!Baskets.Value) <= 59,1,Sum(Fields!Baskets.Value) >= 60 and Sum(Fields!Baskets.Value) <= 108 ,2)
Is it possible to get a sum of the values at the end of the report from the above statement? If so, how?

Thanks.
 
You should just be able to wrap this in a sum function - have you tried this approach?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top