Nesting of aggregate functions...is not allowed

[yuchen1]

I have a few calculated fields created in my dashboard,
monthly Cost per Unit(CPU) = coalesce(sum(totalcost)/sum(quantity), 0)
baseline Cost per unit(CPU) (Trailing 12 month average cost per unit) = windowSum(sum(totalcost),[{month_period} ASC],12,0, [{item_id])/windowSum(sum(quantity),[{month_period} ASC],12,0, [{item_id}])
cost reduction/increase = coalesce(({monthly CPU}- {baseline CPU})*{quantity}, 0)
I have the above created successfully,
now I want to quantify the reduction and increase scenarios respectively, but i got the error message that 'nesting of aggregate function is…not allowed.

1. when monthly CPU>=baseline CPU, then it is a potential reduction in cost, so the calculation is sumif({cost reduction/increase}, monthly CPU>=baseline CPU)
2. when monthly CPU<baseline CPU, then it is a potential increase in cost, so the calculation is sumif({cost reduction/increase}, monthly CPU<baseline CPU)

Any ideas how can I bypass this error?

[Giridhar.Prabhu]

See if this helps

Nesting aggregation for ifelse

Hi, I have a calculated field: If the ${customerVSrev} paramater = ‘No. of Customer_’, then get the count of customer_. if ${customerVSrev} paramater=‘Revenue’ then get the sum of revenue. ifelse(${customerVSrev}=‘No. of Customer’,distinct_count({sfdc_customer_id}), ${customerVSrev}=‘Revenue’,sum({rev_gar}),NULL) users are asking if we can provide the mean for those. Meaning update the logic to become: If the ${customerVSrev} paramater = ‘No. of Customer_’, then get the MEAN of the count of…