2 Replies Latest reply: Nov 4, 2018 1:09 AM by Scott Allen RSS

    If Statement for Background Color

    Scott Allen

      Hello,

       

      I am trying to have a background color based on an If statement, and I cannot seem to get the syntax right.  I have done a number of iterations on the following formula, and even when it says OK, it is not showing up in the background.  Wondering if anyone can see if I am missing components in my calculation (i.e. $, ', etc.)?  Each of the expressions, independently, work.  Here is the expression:

       

      if(

      sum({<[DimDateSOC.CalendarYear]={2018},[DimDateSOC.MonthOfYear]={1,2,3,4,5,6,7,8,9,10}>} [Episode.IsAdmit])

      >=

      sum({<[DimDateSOC.CalendarYear]={2017},[DimDateSOC.MonthOfYear]={1,2,3,4,5,6,7,8,9,10}>} [Episode.IsAdmit])

      ,RGB(Green),RGB(Red))

       

      Thank you in advance for your help!