Add Total of a Row Group that is filtered

  • I have a row group that filters data in the dataset. The detail rows are correct and it accurately filters the data, but the Add Total of the row group is including the rows that are being filtered in the row group.

  • Please provide some example for this... it would be better that way

    -RP
  • I found a solution. You need to add an IIF within the Sum statement that evaluates the value of a field and if true, refers to the numeric field that I am adding and 0 if not true.

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

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