0 Replies Latest reply: Nov 30, 2011 7:23 AM by maibangbee RSS

    Adding Input Field to main data

      Hi All

       

      Is there a way I can add input field's total to actual data total based on an expression?

       

      E.g.

      Forecast OctForecast NovForecast Dec
      1002030



       

       

      Actual OctActual NovActual Dec
      501000300



       

       

      I would like the expression to be based to Month(today()).  So if Month(today())<Invoice month, then display Acutal, else display Forecast. So the expected should be:

      Final OctFinal NovFinal Dec
      502030



      Its 50 because Oct is passed and its 20 in Nov and 30 in Dec respectively because the invoice month is greater than this month.

       

       

      Please help.