Alternative to LOOKUP with non-composite hierarchies

ChrisHeathcote
Community Boss

Re: Alternative to LOOKUP with non-composite hierarchies

Hi All, 

 

I appreciate all your efforts to help. The solutions provided while appearing to offer a solution are all too lengthy and cumbersome where this can be resolved by redesigning the lists and removing the list subtotals. 

As this is a client model in which I have not been the principle model builder this will be my suggestion to the model team. 

 

Thanks

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA