Text mode Column rules on a report

[Nijs_Gold_23]

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.

[Rafal_Bainie]

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

[Nijs_Gold_23]

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

[Rafal_Bainie]

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