none
MULTIPLE IIF CONDITION

    Question

  • I am trying to put a rag colour to text using the expression builder The RAG colours are the standard RED - AMBER -GREEN except the condtions to each are 2

     

    For example A figure is between 70% and 75% and the code for this is P

    I can manage to get this to work with the condition being between the percentage but not if it also meets the code P criteria.

     

    Any assistance in mulitple conditions would be great  

     

    Thursday, November 29, 2007 1:47 PM

All replies

  • Hi!

     

    So, you have tried something like:

     

    =iif((fields!figure.value >= 70) and (fields!figure.value <= 75) and (fields!code.value = "P"), "Red", iif(etc...

     

    I have expressions like this working in several of my reports.  Hope that helps!  Let me know if you are receiving an error or if nothing seems to be happening.

     

    Ryan

    Thursday, November 29, 2007 2:42 PM