Hi Guys U have a similar issue - pls help =IIf(Fields!Weekday.Value="Su" or Fields!Weekday.Value="Sa" or Len(Fields!HOLIDAY.Value)>0, (Fields!GENERAL.Value + Fields!LAUNCH.Value + Fields!SHIFT.Value + Fields!OCESAWE.Value + Fields!OCESAWD.Value + Fields!WEPHWORK.Value + Fields!OCREMWE.Value + Fields!OCREMWD.Value) * 1.5, (Fields!GENERAL.Value + Fields!LAUNCH.Value + Fields!SHIFT.Value + Fields!OCESAWE.Value + Fields!OCESAWD.Value + Fields!WEPHWORK.Value + Fields!OCREMWE.Value + Fields!OCREMWD.Value) ) To get a columnn called "Total Weighted" and this column have several rows. E.g. 1. ID Total Weighted 2. 111 21 3. 121 49 How can I get the total of the "Total Weighted?

Hey, What error u are getting by thisHope this will help you !!! Sanjeewan

can you just do a sum of all that? Like, =sum(IIf(Fields!Weekday.Value="Su" or Fields!Weekday.Value="Sa" or Len(Fields!HOLIDAY.Value)>0, (Fields!GENERAL.Value + Fields!LAUNCH.Value + Fields!SHIFT.Value + Fields!OCESAWE.Value + Fields!OCESAWD.Value + Fields!WEPHWORK.Value + Fields!OCREMWE.Value + Fields!OCREMWD.Value) * 1.5, (Fields!GENERAL.Value + Fields!LAUNCH.Value + Fields!SHIFT.Value + Fields!OCESAWE.Value + Fields!OCESAWD.Value + Fields!WEPHWORK.Value + Fields!OCREMWE.Value + Fields!OCREMWD.Value) ) )

can you just do a sum of all that? Like, =sum(IIf(Fields!Weekday.Value="Su" or Fields!Weekday.Value="Sa" or Len(Fields!HOLIDAY.Value)>0, (Fields!GENERAL.Value + Fields!LAUNCH.Value + Fields!SHIFT.Value + Fields!OCESAWE.Value + Fields!OCESAWD.Value + Fields!WEPHWORK.Value + Fields!OCREMWE.Value + Fields!OCREMWD.Value) * 1.5, (Fields!GENERAL.Value + Fields!LAUNCH.Value + Fields!SHIFT.Value + Fields!OCESAWE.Value + Fields!OCESAWD.Value + Fields!WEPHWORK.Value + Fields!OCREMWE.Value + Fields!OCREMWD.Value) ) )

Hi SilverIS, Thanks for the question and other partners' replies. In order to get the total value of one column, you need to use sum function with one scope as the parameter. This parameter can be one group name or one dataset name. Detail information, please refer to: Sum Function (Reporting Services) Thanks, Sharp WangPlease remember to mark the replies as answers if they help you and unmark them if they provide no help.