I added the code (below) which TM1 accepted from a syntax perspective, but I have to figure out where it's failing since the cube is not returning values for Turns (Gross)
Code: Select all
['Actual', 'Turns (Gross)'] = C:
IF(!PERIOD MAIN @= 'Jan '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month' % !PERIOD MAIN @= 'Feb '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month'
% !PERIOD MAIN @= 'Mar '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month' % !PERIOD MAIN @= 'Apr '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month'
% !PERIOD MAIN @= 'May '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month' % !PERIOD MAIN @= 'Jun '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month'
% !PERIOD MAIN @= 'Jul '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month' % !PERIOD MAIN @= 'Aug '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month'
% !PERIOD MAIN @= 'Sep '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month' % !PERIOD MAIN @= 'Oct '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month'
% !PERIOD MAIN @= 'Nov '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month' % !PERIOD MAIN @= 'Dec '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD Rolling 12-Month',
['Actual', 'Total Departments', 'Cost of Goods Sold'] ,Continue) \
IF(!PERIOD MAIN @= 'Jan '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD' % !PERIOD MAIN @= 'Feb '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD'
% !PERIOD MAIN @= 'Mar '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD' % !PERIOD MAIN @= 'Apr '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD'
% !PERIOD MAIN @= 'May '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD' % !PERIOD MAIN @= 'Jun '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD'
% !PERIOD MAIN @= 'Jul '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD' % !PERIOD MAIN @= 'Aug '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD'
% !PERIOD MAIN @= 'Sep '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD' % !PERIOD MAIN @= 'Oct '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD'
% !PERIOD MAIN @= 'Nov '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD' % !PERIOD MAIN @= 'Dec '|SUBST(DB('GLOBAL VARIABLE','Current Year','String'),3,2)|' YTD',
['Actual','Total Departments', 'Inventory-FIFO (Gross)'],Continue);
If(conditions=true, take COGS value, else continue) \ If(conditions=true, take Inventory-FIFO value, else continue)