Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.