Register

INV01 Line Item Formulas and Results

neg177
Regular Contributor

INV01 Line Item Formulas and Results

Hi,

 

Attached are the Formulas and Results for INV01. My weekly numbers are off by 2 units and my monthly numbers are off as well by the total number of units by weekly numbers are off. I have checked all my inputs and cant seem to find the problem. Attached are my pics of INV01, Please advice. 

 

Thank you 

2 REPLIES 2
filip.sypniewski
Master Anaplanner/Community Boss

Re: INV01 Line Item Formulas and Results

Hi @neg177,

you have couple of mistakes in your formulas. I wrote down the points here: https://community.anaplan.com/t5/Anaplan-Platform/INV01-Line-Item-Formulas/m-p/85066/highlight/false... 

neg177
Regular Contributor

Re: INV01 Line Item Formulas and Results

I got the formula. I used HALFYEARVALUE to get my values for the Line Item Safety Stock Target. 

 

Thank you