in the activity of level2 sprint 3 model building, I am supposed to use conditional formatting in Ending Inventory line item based on Safety Stock Target values for different Product SKU (display Ending Inventory as red when the value is less than the Safety Stock Target value) but I am not able to set minimum and maximum values as different SKU have Different Safety Stock Target values.
Yes that's correct Add another line item with the formula: IF Ending Inventory < Safety Stock Target then 1 ELSE 0 Then use this line item for conditionally formatting the Ending Inventory line item
The advantage with the static value of 1 is that now you can easily set the minimum and maximum value to 0 and 1 respectively and not worry about the actual difference in the inventory and safety stock
In the DEM03 Demand Forecast module, it was instructed to set up a Forecast cf line item for conditional formatting.
The Safety Stock Exception Count line item in the INV01 Inventory Ordering can serve this purpose, but the cf naming practice does not seem to be utilized here if we depend on Safety Stock Exception Count as the name of the format condition, perhaps Ending Inventory cf would be more consistent with suggested naming conditions for purpose of setting up UX.