Nested Aggregate Error

• willie.johnson 68696

  Grasshopper

  Points: 23

  More actions

  April 2, 2014 at 7:50 am

  #285297

  I need to get a sum of a column, but it needs to be the sum of only the visible rows. My visibility code is based on a row number expression as the data is coming from a sharepoint list and I am not able to make changes to the list to add a row number column:

  =IIF(RowNumber("SC1Test2") < 9, True, False)

  When trying to sum the column based on the row number value, I keep receiving an error stating that aggregate functions cannot be nested inside other aggregate functions. Is there another way to accomplish this? Here is my code:

  =SUM(IIF(RowNumber("SC1Test2") > 8, Fields!Quantity.Value*Fields!LaborHours.Value*Fields!LaborUnitCost.Value, 0))

  Thanks in advance.