2 Replies Latest reply: Mar 1, 2017 4:21 AM by Sunny Talwar RSS

    Expression inside IF Statement

    Val Barnes

      I am having issues with the following if statement:

       

      What am I doing wrong here ? I need to expand: Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') on a Dim.

       

      IF(MonthOfService >= $(=Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') ),MonthOfService , Null() )

       

      I've also tried:

      IF(MonthOfService >= Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') ,MonthOfService , Null() )


      but no luck.