4 Replies Latest reply: Dec 17, 2015 10:18 PM by Jim Chan RSS

    How to write this If statement to a SET analysis statement?

    Jim Chan

      Hi guys,

       

      I dont know why, this IF statement didnt seem to be working. May i know is there another way to writing this statement? perhaps SET analysis?

       

      = IF(DR_DTLS_MONTHNAME = 'Jan','Month Actual  $(vPriorMonth) $(vPriorYear)','Month Actual  $(vPriorMonth) $(vMaxYear)')

       

      Rgds,

       

      Jim