Background Expression not applied to column

Kaushik2020 — Mon, 10 Mar 2025 08:00:43 GMT

Dear All,

Below is my set Expression where i am applying background color as Red and Green based on Rank.

I am using a table with ID, Name and Value. this condition is applied in Background expression for Column Value.

if(CatId='22',
if(Rank(Num(avg(aggr(Sum({$<Year=, Month=, Day=,EmpName=, CustomCatLabel={'22'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Value), EmpCode,CatId,EmpName)),'#,##0%'))<=10,'Green',
if(Rank(Num(-avg(aggr(Sum({$<Year=, Month=, Day=, EmpName=,CustomCatLabel={'22'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Value), EmpCode,CatId,EmpName)),'#,##0%'))<=10,'Red',
Num(avg(aggr(Sum({$<Year=, Month=, Day=, EmpName=,CustomCatLabel={'22'},
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
Value), EmpCode,CatId,EmpName)),'#,##0%'))),
if(CatId='23','White',
if(CatId='24','White',
if(CatId='25','White',
if(CatId='26','White','White'))))

Here column name has Arabic text. When applied with Id and Name column, Value is showing all Green,

with just Id, this condition works well.

Any suggestions on what I am missing ?

thanks in advance.

topic Background Expression not applied to column in App Development

Background Expression not applied to column