create a formula to show actual and forecast in same line
I need to be able to show actual data and forecast in same line item.
I have an actuals line item, forecast line item, then total view line item.
Formula i have written is IF Time filter.Actual Months THEN Actual ELSE Total Forecast
It returns the forecast but I should be able to see actual months data, it returns 0.