Inventory Measures

Hi,

I am having some problems in setting my BOP values according to the BOS.

My calc rules are:

Rule 1: BUWPBOPC=if(current==indexfirst([clnd].[ssn]),BUWPBOSC,lag(BUWPEOPC))

Rule 2: BUWPEOPC=if(BUWPUnelapsedB,BUWPEOPR*(1-BUWPCMUp),ignore)

Rule 3: BUWPBOPR=if(current==indexfirst([clnd].[ssn]),BUWPBOSR,lag(BUWPEOPR))

Rule 4: BUWPEOPR=if(BUWPUnelapsedB,BUWPBOPR+BUWPInvAddnR-BUWPInvRedR,ignore)

Rule 5: BUWPBOPU=if(current==indexfirst([clnd].[ssn]),BUWPBOSU,lag(BUWPEOPU))

Rule 6: BUWPEOPU=if(BUWPUnelapsedB,BUWPBOPU+BUWPInvAddnU-BUWPInvRedU,ignore)

Scenario 1: When I open only one season in the workbook, the above mentioned rules works perfectly and my first month's BOP gets the same value as BOS. See the attacment BOS and BOP_Correct