I'm trying to troubleshoot a formula for which there is no delegation warning in the app designer. When I play the app however in a debug session, it gives me a delegation warning on the formula.
Which one should I believe?
Here's the formula:
With(
{
YearStartDate: Date(Year(Today()), 1, 1),
YearEndDate: DateAdd(Date(Year(Today()), 1, 1), 1, TimeUnit.Years),
MonthStartDate: Date(Year(Today()), Month(Today()), 1),
MonthEndDate: DateAdd(Date(Year(Today()),Month(Today()),1),1,TimeUnit.Months),
_preFilter:
Filter(Projects_1,
'Opportunity Status'.'Dashboard Sold Display' = "yes",
Status = 'Status (Projects_1)'.Active
)
},
Text(
Coalesce(
Sum(
Filter(
_preFilter,
'OP Status Service Ticket Sold Date' >= YearStartDate,
'OP Status Service Ticket Sold Date' < YearEndDate
),
'Project Value'
),
0),"[$-en-US]$###,##0"
)
)
