Announcements
hi expert,
i want border color to change to red only if value is greater than1 but in my code below am getting red even though value is 1
if(Sum(Filter(Forecast,EmployeeName=varRecrd.EmployeeName),Jan)+DataCardValue13.Text>1,Red,Parent.BorderColor)
@Anonymous
if(Sum(Filter(Forecast,EmployeeName=varRecrd.EmployeeName),Jan)+
Value(DataCardValue13.Text)>1,Red,Parent.BorderColor)
Still same
Delegation warning, sum operator not suppoerted
Try this for the BorderColor property
With( { fltrd: Filter( Forecast, EmployeeName=varRecrd.EmployeeName ) }, If( Sum( fltrd, Jan ) + Value(DataCardValue13.Text) > 1 Red, Black ) )
Still Same
It seems to be showing datacardvalue13.Text as the problem now.
i fixed using
iferror
With({fltrd:Filter(Forecast,EmployeeName=varRecrd.EmployeeName)},IfError(Sum(fltrd,Jan)+Value(DataCardValue13.Text)>1,Red,Black))
but issue now is when the value ismore than1 the border color is not changing red
Further, over here the value is
my splist value is already 1 and when i try to edit this value its already adding the current text value
is there any way to use the condition
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179
