Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The below is 4 indexes of a code:
I want it to be like this, when index B is less than 70%, it is marked orange, but the summary row is not marked orange:
But I don't know how to write the formula.
I use the formula :if(count(distinct Code)=1 and sum(index_B)<0.7,RGB(255,128,64),)
But it only works when there are more than one code.
If there is only one code, it would be like the below:
How can I write the formula?
Hi @Nora104
Little bit confused.
Try like below
if(RowNo()<>0 and count(distinct Code)=1 and sum([index B])<0.7,RGB(255,128,64))
HI @Nora104
Can you provide the sample app..
Hi @Nora104
For me, its working fine.
Hi @Nora104
Little bit confused.
Try like below
if(RowNo()<>0 and count(distinct Code)=1 and sum([index B])<0.7,RGB(255,128,64))
Wow, it's just what I want! Thank you!