Skip to main content
Solved

Conditional layout condition columns not commutative

  • October 29, 2021
  • 1 reply
  • 51 views

I noticed that, when making a conditional layout, if I specify the condition like this:

the relevant columns in the table look like this, where I’d expect a conditional layout to be applied.

However, by simply interchanging the columns in the condition

I do get a working conditional layout:

What’s going on here? I’d expect the order of the columns in the Condition to not matter. Is this intended, or would you like me to report this as a bug?

Best answer by Mark Jongeling

Hi Dries,

Sounds a bit like either an oversight. The first screenshot is the correct behavior. The second one is not. 

If you want this to work correctly, then you'll need two conditional layouts; one which looks to see if the Year end old is filled or not - if not Year end is Red, and two to compare both but with the added condition that Year end old is not null.

Feel free to report this in TCP :thumbsup_tone1:

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3936 replies
  • Answer
  • October 29, 2021

Hi Dries,

Sounds a bit like either an oversight. The first screenshot is the correct behavior. The second one is not. 

If you want this to work correctly, then you'll need two conditional layouts; one which looks to see if the Year end old is filled or not - if not Year end is Red, and two to compare both but with the added condition that Year end old is not null.

Feel free to report this in TCP :thumbsup_tone1:


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings