Text mode Column rules on a report

Is there a way to apply two conditions on a single column rules at the same time on the Report view?

for example, I want to display 'text' on a report column when status is 'xyz' and XDate is blank.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Community Advisor

I think this is possible, and likely in 2 different ways:

1. by using valueexpression directly on the report

2. by creating custom field that would combine both fields into single one and leverage that new field in a report

Level 7

can you help/guide me how to write valueexpression on the column custom rule?

If this helped to solve your problem, please mark it as 'solved' so others can also find the solution faster. Thanks!

Community Advisor

hi,

sorry, I might need to take back 1. I'm not so sure anymore and lack time to playaround

for 2. here is an example of custom field i created and subsequently used for conditional formatting in the report:

IF(({status}="NEW")=true && {DE:NLT}>$$NOW,"blank",IF((({status}="INP" || {status}="BES")=true &&{DE:NLT}<$$NOW),"Green","red"))

hope this helps

Sign up