Nesting of aggregate functions...is not allowed

[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…