Answered

Sum and Help Avoiding a Delegation Flag

(0) Share

Report

Posted on by kgordish

193

Can someone assist me with avoiding this delegation flag associated with Sum.
The delegation flag... the stuff simple nightmares are made of.
Thank you in advance.

Text(Sum(
Filter(
Gateways,
'VDates' >= DatePicker1.SelectedDate,
'VDates' <= DatePicker2.SelectedDate,
Gateways.Value = "FJ",
BPR.Value = "Y"),
NTEI
) / Sum(
Filter(
Gateways,
'VDates' >= DatePicker1.SelectedDate,
'VDates' <= DatePicker2.SelectedDate,
Gateways.Value = "FJ",
BPR.Value = "Y"),
NTEI_Total
) * 100,"0%")

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@kgordish

With({wGate:Filter( Gateways,'VDates' >= DatePicker1.SelectedDate, 'VDates' <= DatePicker2.SelectedDate, Gateways.Value = "FJ",BPR.Value = "Y" ), num: Sum(wGate,NTEI), denom: Sum(wGate NTEI_Total) }, Text(num/denom*100,"0%") )

Was this reply helpful? Yes No
kgordish 193 on at

Like (0)

Report
Copy link

Link copied!
This formula works. Added a comma prior to NTEI_Total.
Still getting a delegation warning. With num and denom sum.

With({Gateways:Filter(
Gateways,'VPP Dates' >= DatePicker1.SelectedDate,
'VPP Dates' <= DatePicker2.SelectedDate,
Gateways.Value = "FDJ",BPR.Value = "Y"
),
num: Sum(Gateways,NTEI),
denom: Sum(Gateways, NTEI_Total)
},
Text(num/denom*100,"0%")
)

With({wGate:Filter( Gateways,'VDates' >= DatePicker1.SelectedDate, 'VDates' <= DatePicker2.SelectedDate, Gateways.Value = "FJ",BPR.Value = "Y" ), num: Sum(wGate,NTEI), denom: Sum(wGate NTEI_Total) }, Text(num/denom*100,"0%") )

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@kgordish

If you are not having more than 2k items in your filtered Gateway list, then you can ignore it. For another approach, see @mdevaney 's blog post here https://www.matthewdevaney.com/sum-rows-in-a-sharepoint-list-with-no-delegation-warnings/

Was this reply helpful? Yes No