1 Reply Latest reply: Aug 16, 2018 10:25 AM by Gabor Tarnoczai RSS

    How to use 'if' & 'between' condition for Background Color Expression

    Ashik Khan

      Hi Experts,

       

      I want to set background color expression and i have tried to use the following statement, please advise what is wrong with these statements:

       

      if([Counts] <= '50', rgb(30,144,255), <---- [Counts] here is measure i have used as master items

      if([Counts] >= '51' , rgb(81,81,81),

      rgb(0,192,0)))


      Other statement which i have tried:


      if(Count(UserID) <= '50', rgb(30,144,255), <---- here count is aggregate function which counts userid

      if(Count(UserID) >= '51' , rgb(81,81,81),

      rgb(0,192,0)))



      I do not know how to use 'between' condition, have tried to search on internet but hard luck...



      Thanks,

      MAK.