We have a requirement to calculate only Total safety days demand (Independent Demand + Dependent Demand) based on number of days maintained in safety days of supply (SUBPERIODNUM KF). All calculations are at day/product/location level.
I tried below logic after TS heuristic run output and it gave correct results. But for location-product where lot sizes are maintained it is not working.
IF(ISNULL("SUBPERIODSOFSUPPLY@DAYPRODLOC") OR("SUBPERIODSOFSUPPLY@DAYPRODLOC" = 0), NULL, ("PROJECTEDINVENTORY@DAYPRODLOC" + ("NETDEMAND@DAYPRODLOC" - "TOTALRECEIPT@DAYPRODLOC")))
Is there any other way to calculate this as it is dynamic in nature