conditional formatting based on multiple fields in Lumira Designer

[former_member559159]

Hello Experts,

There are two Column( Start Date and Finish Date) in my Crosstab. Our User wants to highlight/format the cells of these columns based on below conditions :

-if both Dates are available then GREEN

-if Start Date is available and Finish Date is not then GREY

-if both Dates are unavailable then YELLOW

This is easily achievable in webi but don't know how to implement this in Lumira Designer.

We are using Lumira 2.1 version.

Thanks in Advance!

[reiner_hille-doering]

Maybe you could create a calculated measure and set you conditional formatting on that?

[TammyPowlas]

Hello - have you tried the steps as outlines in this Visual BI blog: https://visualbi.com/blogs/sap/sap-businessobjects/sap-lumira-designer/conditional-formatting-sap-lu...

[former_member559159]

Hi Tammy,

Thanks for the quick response.

I already looked to this blog. This is not helpful as it talks about how to implement the conditional format in Lumira Designer in general. I already know how to implement the conditional format in Designer.

In our scenario we have to create a formatting Rule based on two fields( AND condition)

The challenge as you can see in above screenshot is that we cannot create a AND condition here.