Friends need your help !!
I am trying to optimize the model with the help of cross-references so that can remove most of the formulas from the model (multiple modules will be optimized if successful).
Source module with 2 months data
April & May months data:
Looking for below result in the Target module
Note: No version; hence the intersection of version + month to be selected from source in below like combination
April = 0+12
May = 1+11
June = 2+10 etc….
Pattern to be followed for the rest of the modules in the same way
Note: So far, may SELECT are placed in the modules line items to pick the specific version data based on month like shown below
IF 'SYS01.Time Settings'.MONTH Number = 1 THEN a[SELECT: VERSIONS.'0+12']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 2 THEN a[SELECT: VERSIONS.'1+11']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 3 THEN a[SELECT: VERSIONS.'2+10']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 4 THEN a[SELECT: VERSIONS.'3+9']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 5 THEN a[SELECT: VERSIONS.'4+8']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 6 THEN a[SELECT: VERSIONS.'5+7']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 7 THEN a[SELECT: VERSIONS.'6+6']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 8 THEN a[SELECT: VERSIONS.'7+5']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 9 THEN a[SELECT: VERSIONS.'8+4']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 10 THEN a[SELECT: VERSIONS.'9+3']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 11 THEN a[SELECT: VERSIONS.'10+2']
ELSE IF 'SYS01.Time Settings'.MONTH Number = 12 THEN a[SELECT: VERSIONS.'11+1']
ELSE 0
