Forum Discussion
Linked data tables - data not pulling
Hello,
I have two tables, one with actuals data and one with forecast data. I have created a table visualisation to show actuals and forecast by cost category. The cost category comes from the Actuals Table as this is where the hierarchy is maintained and the forecast data is linked via the following formula
Forecast_V1 =
CALCULATE(
-SUM(cognos_costcentre_forecast[value]),
TREATAS(
VALUES(fusion_costcentre_actuals[GParentAccount]),
cognos_costcentre_forecast[GParentAccount]))
where GParentAccount is the cost category.
The issue I have is if there isn't any data in the actuals for a particular cost category it doesn't pull the forecast data if that isn't blank. For example, we forecast £10k for postage but in actuals postage was £0, so both actuals and forecast is showing as blank.
Is there a quick way to show forecast data even if the actuals data is blank, without having to change the structure of the table?
Thanks,
Louise
1 Reply
use COALESCE for these situations.
