Formula to show Items with Majority of Forecast

[DeeCeesQuestion]

Hi - my company has four different warehouses and the same stock code can be in both warehouses.  Within the warehouse, we have customer groups and forecasts are created for each stock code by warehouse and customer group.

For my warehouse, "88" in the example below, I want to show items where the stock codes make up the majority of the forecast compared to the other warehouses. I don't know how to create the command or if I'm in the right place.

[Anonymous · Accepted solution]

Hi @DeeCeesQuestion ,

You can try formula like below:

TotalForecast = SUM('Table'[Jan FC]) + SUM('Table'[Feb FC]) + SUM('Table'[Mar FC])

Warehouse88ForecastPercentage = 
IF(ISBLANK([TotalForecast]), BLANK(), 
   DIVIDE(
      CALCULATE(
         [TotalForecast],
         VALUE('Table'[Warehouse]) = 88
      ),
      [TotalForecast]
   )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly