Creating a colour for two different values

[former_member568297]

Hi this is my formula but what am I doing wrong

if {@Taking Date Away} >=28 and {PatCPlan.Tx_Intent} = "1_Radical") then crred or {@Taking Date Away} >=14 and {PatCPlan.Tx_Intent} = "2_Palliative" then crFuchsia else crnocolor

I have put this in the background colour section with in the formula but unsure how to get it working.

Thanks

Philippe

[abhilash_kumar · Accepted solution]

Hi Philippe,

Try:

if {@Taking Date Away} >=28 and {PatCPlan.Tx_Intent} = "1_Radical" then crred

Else if {@Taking Date Away} >=14 and {PatCPlan.Tx_Intent} = "2_Palliative" then crFuchsia else crnocolor

-Abhilash

[former_member568297 · Accepted solution]

Thank you that works