4 Replies Latest reply: Oct 26, 2017 8:47 PM by William Walsh RSS

    Data Load Editor Invalid Expression

    William Walsh

      Hi,

       

      I am trying to use this expression in the data load editor to create a new table but I keep getting the invalid expression error.

       

      If((1-(Sum(If(month= currentmonth, Spend))/Sum(If(month= currentmonth, Forecast)))) > .20, 'Red',

          If((1-(Sum(If(month= currentmonth, Spend))/Sum(If(month= currentmonth, Forecast)))) > - .20, 'Green')) as RAG

       

      What would need to be changed to make this able to work.

       

      Regards,

      William