Is there a way I can add input field's total to actual data total based on an expression?
|Forecast Oct||Forecast Nov||Forecast Dec|
|Actual Oct||Actual Nov||Actual 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 Oct||Final Nov||Final 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.