sprint 3 Country summary Module

Hi Members , 

 

Tried creating the below mentioned requirement with the formula written below , but not getting it correct .

 

 

Line Item Format Purpose
Safety Stock Flag CountNumberIdentify number of Stock Exceptions by Country and Product Family
 
 
 
IF 'INV01 Inventory Ordering'.Safety Stock Exception Count =1 THEN [SUM: 'SYS08 SKU Details'.Product Family,SUM: 'SYS06 Location Details'.Country] ELSE 0
 
Can you help ?
 
Thanks 
 

Comments

  • @BapinB 

    No,

     

    the formula for Safety Stock Flag Count will be

    'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

     

    Thanks,

     

    Jagadish Dash

  • But Country madein is not there in SYS08 SKY Detail ??