J C
asked on
Trying to sum in group footer based on condition
I have one footer value in my report that is based on an expression
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.Valu e = 1, Fields!amount.Value - SUM(Fields!BudgetByProduct .Value),NO THING),"Da taSet1")
I cannot use inner and outer aggregates when in association with a dataset. Does anyone know how I could compute this value?
Expression:
=Fields!amount.Value - SUM(Fields!BudgetByProduct
I have a parent grouping with a footer and need to SUM based on a condition. I tried this
=Sum(IIF(Fields!IsOpt.Valu
I cannot use inner and outer aggregates when in association with a dataset. Does anyone know how I could compute this value?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.