Power Platform Community Forum Thread Details

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:

Filter(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!

Categories:

Building Power Apps