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?



      Forecast OctForecast NovForecast Dec



      Actual OctActual NovActual Dec



      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

      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.