topic Re: How to break dynamic expression with aggr from interacting with a filter in App Development

How to break dynamic expression with aggr from interacting with a filter

RenewalBIUser — Sat, 16 Nov 2024 19:06:40 GMT

Hello,

I'm trying to get this formula to not move when a RevenueRecognizedDate is selected, but it keeps changing. Any ideas?

sum({1<EventType = {'Order','Change Order'}, Work_Order_Type__c = {'Install'}, IsOrderCancelled = {0}, RollingMonthFlag={1}, IsWorkOrderStatusCancelled={0}, RevenueRecognizedDate =>} Total_Labor_Cost__c)/

Aggr(NoDistinct sum({1<EventType = {'Order','Change Order'}, IsOrderCancelled = {0}, IsItemCancelled = {0}, RollingMonthFlag={1}, RevenueRecognizedDate =>} Total_Retail_Price__c),"Month and Year")

Re: How to break dynamic expression with aggr from interacting with a filter

kaushiknsolanki — Sun, 16 Feb 2020 06:49:49 GMT

Try this.

Aggr({<RevenueRecognizedDate =>}NoDistinct sum({1<EventType = {'Order','Change Order'}, IsOrderCancelled = {0}, IsItemCancelled = {0}, RollingMonthFlag={1}, RevenueRecognizedDate =>} Total_Retail_Price__c),"Month and Year")

Re: How to break dynamic expression with aggr from interacting with a filter

RenewalBIUser — Mon, 17 Feb 2020 12:56:10 GMT

Thanks for the suggestion, however, it still filters down to the RevenueRecognizedDate range selected using that set analysis.