Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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")
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")
Thanks for the suggestion, however, it still filters down to the RevenueRecognizedDate range selected using that set analysis.