SQL Server Performance

RunningValue

Discussion in 'SQL Server Reporting Services' started by mahima, Jan 8, 2007.

  1. mahima New Member

    Hi

    In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***%

    For the Row % under total i write like this:

    =Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2)

    For the *** % under cumulative total the expression is:

    =RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,sum,"AgeByGender")

    But i am getting this error:

    The Value expression for the textbox '*** %' 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.

    How to get the cm % for the Cumulative total

    Please help me

    Thanks in advance

Share This Page