Hi All
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.
Please help.
