Post reply

how to exclude hidden rows from total based on two parameters

  • January 28, 2016 at 6:15 am

    #311141

    Hi,

    How do I exclude to hidden cells based on two parameters.

    I currently have the following expression which works fine, however I have now added in another parameter called Show Team Mangers. Therefore if Show Team Mangers is set to No then don't include them in the total, but I am struggling to put the two together as they are separate commands.

    =Floor(IIF(Parameters!Report_Type.Value = "Average", (Sum(Fields!ACD_Calls.Value) / CountRows()), Sum(Fields!ACD_Calls.Value)))

    is this possible.

    thanks

  • January 29, 2016 at 9:34 am

    #1855281

    Given your description can you not just filter the dataset based on the Show Team Managers parameter? Their values would not be included in the totals and it sounds like their other details would be hidden anyway.

Viewing 2 posts - 1 through 1 (of 1 total)

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