issue with the inventory formula of the line item.


i have been stuck at it for more than 90 mins.The following are the formulas of the line items, and modules and the values shipping by weeks are zero and issue with the dimension.can someone check and provide me with correct formulas. The formulas are obtained from following attachment.

Thank you

with regards



  • Hi @mohammed007 ,

    Seems you need to add one more lookup for shipping time in weeks.
    Along with sys08 use the shipping method for lookup.

    Formula: 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

    Hope this helps :).


  • can you provide me with formula for the shipping method and the shipping with week is showing the same issue.

    for the shipping method to be populated with the values i have use i have filled the TRA01 line items with formulas but i don't see any values in the inventory module.

    thank you