You’re offline. This is a read only version of the page.
Announcements
523
I wondered if someone could help me. I understand that the Sum() function is subject to the delegation limit. But if I placed a delegable function within the Sum() function, am I right thinking that the delegable function would still work with delegation.
i.e. I have the following formula:
Share
ReportFilter(Projects,'Approx Close'>=Date(Year(Today()),1,1),'Approx Close'<=Date(Year(Today()),12,31),'Opportunity Status'.Forecasting="Sold"||'Opportunity Status'.Forecasting="Closed")which (being delegable) filters 3000 projects down to 100 instances.
Am I correct thinking I can then use the sum function in order to calculate the total of the "proj value" column eg:.
Text(Sum(Filter(Projects,'Approx Close'>=Date(Year(Today()),1,1),'Approx Close'<=Date(Year(Today()),12,31),'Opportunity Status'.Forecasting="Sold"||'Opportunity Status'.Forecasting="Closed"),'Proj. Value ($)'),"[$-en-US]$#,###.00")And still have the formula work on those 100 project instances?
I hope that makes sense!
Yes, that should work. But you will still get the delegation warning on the Sum() because the editor isn't sophisticated enough to detect that the inner function will bring the list items below the data row limit. The fact that you are using an inner function doesn't guarantee that it will filter the list below the limit. But if you know it will then you can safely use he non-delegable SUM() even though the editor gives a warning.
All responses (
Answers (
