Is there a way I can add input field's total to actual data total based on an expression?
E.g.
Forecast Oct
Forecast Nov
Forecast Dec
100
20
30
Actual Oct
Actual Nov
Actual Dec
50
1000
300
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
50
20
30
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.
