1 Reply Latest reply on May 28, 2013 9:28 AM by Dan Huff

    If statement with multiple measures

    Chloe Riordan

      Hi, I have tables listing the % difference month over month for visits and unique visits.  I'm trying to create a calculated field where for each visit type I can highlight variances greater than 10% green, less than 10% red, and else leave it black.  This is straightforward enough to just for one of my measure values, ie: 

      if (ZN(SUM([Visits])) - LOOKUP(ZN(SUM([Visits])), -1)) / ABS(LOOKUP(ZN(SUM([Visits])), -1))<-.10

      then "red"

      elseif (ZN(SUM([Visits])) - LOOKUP(ZN(SUM([Visits])), -1)) / ABS(LOOKUP(ZN(SUM([Visits])), -1))> .1

      then "green"

      else "black"

      end

       

      is there a way to do the same for [Unique Visits] in the same table? 

       

      Thanks!