Need urgent help with the PARENT formula; should it be something similar to PARENT(ITEM('Sub-regions L3'))
I'm also lost about the Projected Goal formula; should it be something similar to Company Goal Set.Final Goal [LOOKUP: 'Sub-regions L3'] * Region Percent
Any help is appreciated and thanks in advance!
I think that the Region Goal Set module should be based on the L2 list... the L1 Parent formula will work better then.
Project Goal comes from the GEO Goal Set module, based on teh L1 parent.