3 Replies Latest reply: Mar 2, 2016 4:18 PM by ilyas kuzu RSS

    IF statement for date in expressions

    ilyas kuzu

      i am trying this expression but it doesnt return any value;

       

      IF ([Reporting Starts] <= date#('2016-02-27','YYYY-MM-DD'),'(Sum([Amount Spent (TRY)]))/(Sum([Video Views])))*3','(Sum([Amount Spent (TRY)]))/(Sum([Video Views]))*4.4')

       

      i also tried;

       

      IF ([Reporting Starts] <= 2016-02-27,'(Sum([Amount Spent (TRY)]))/(Sum([Video Views])))*3','(Sum([Amount Spent (TRY)]))/(Sum([Video Views]))*4.4')

       

      but it didnt worked as well. could you help me please