Aggregate Functions Cannot be Nested Inside Other Aggregate Functions RRS feed

  • Question

  • Hi,

    I am getting the following error message when I try to deploy my report in SSRS.

    The Value expression for the textrun 'Textbox3.Paragraphs[0].TextRuns[0]' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue).  Aggregate functions cannot be nested inside other aggregate functions.

    the expression I am using is:

    =(sum(IIF(Fields!Grouped.Value, Fields!Pay.Value,0)/(sum(Fields!Grouped.Value))))

    Grouped is a count in SQL and Pay is numeric field which is just data.

    I have tried lots of different methods but still getting the error message.


    • Moved by Sunil Hurkadli Tuesday, February 9, 2016 7:58 AM Not related to VSTS
    Monday, February 8, 2016 5:25 PM


All replies