Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to change the background color of the cell with the largest OVER RATIO value in the table below.
so, I wrote something like this
IF(COUNT("OVER COUNT")/Count("TOTAL COUNT")=(MAX(COUNT("OVER COUNT")/COUNT("TOTAL COUNT"))), 'RED')
BUT an error occurs.
Please let me know how to solve it.
Hi Park,
You can't use two aggregation function without aggr fn.
Try like below
IF(COUNT("OVER COUNT")/Count("TOTAL COUNT")=(MAX(Total Aggr(COUNT("OVER COUNT")/COUNT("TOTAL COUNT") ,urdimension))), 'RED')
or, store into variable and reuse where required.
Hi MayilVahanan,
You have hepled me this time and before. Thank you.
I wrote the sentence you gave me.
No error occurred, but the background color did not change.
I'm sorry, but one more advice and what does 'urdimension' mean?
Hi
urdimension means, dimension used in the chart