For some reason, When I use the expression total for the below IF Statement, it seems to display as true even though we are in Nov. - NUM(month(today())) is definitely greater than data in January - Please see attached for illustration.
The First Chart represents Forecast Data per month.
The Second Chart Represents the Actual Data from SAP
The Third Chart is the summary.
And my IF statement is to say: If the month of purchase is less than this month, then display Actual data (i.e Second Chart) and if the month of purchase is greater than this month, then display forecast data.