How to config conditional formatting cross different data column

Apliqo UX
,
1

Hi all,

I’m trying to setting table format in UX next gen. I want to highlight cell in pink under “base period” and “BUD” column when the cell value = ratio in the first column. It seems doesn’t work. Here is the screenshot of how i setting the column format below. Is there anything wrong?

image
image2174×1240 154 KB

image
image1920×703 163 KB

2

Hi @tcui ,

I think UX is not recognizing the column as it is adding with “*” at the beginning of the Data Column.

Try going into the JSON and removing it, leaving just “Type” as the datareference, it should then work..

image
image1323×618 31.3 KB

Hope this helps!

3

Yeeeees！ It works! Thanks!!

4

Hi @tcui

There’s currently a bug and stacked columns in combination with data column for the condition doesn’t work via the GUI. This should be fixed in the upcoming release.

In the meantime as indicated you can edit the json directly to make it work.