I have one footer value in my report that is based on an expression
=Fields!amount.Value - SUM(Fields!BudgetByProduct.Value)
I have a parent grouping with a footer and need to SUM based on a condition. I tried this
=Sum(IIF(Fields!IsOpt.Value = 1, Fields!amount.Value - SUM(Fields!BudgetByProduct.Value),NOTHING),"DataSet1")
I cannot use inner and outer aggregates when in association with a dataset. Does anyone know how I could compute this value?