2 Replies Latest reply: Feb 26, 2015 11:51 PM by Prashant Sangle RSS

    Need help removing IF statement in front of Set Analysis

      Can someone please help me figure out how to get rid of this IF statement in the beginning of my SET analysis?


      This script works fine and returns the correct values:


      =if(MonthYear= date($(=max(MonthYear)),'MMM-YYYY'),
              CheckYear = {$(=Max(CheckYear))},
              EarningsHistoryYN -= {1},
              NonCashYN = {0}
          [Current Earnings])


      Any help would be appreciated.