It is quite similar to what we are using now but I can certainly pick up some bits from this and put it in our template.

Looks like excel is the...

I changed the IIF comparison to use the name it improved the performance a bit still very slow

New IIF

IIF(

(

[GL Hierarchy].[GL Acct Code].CurrentMember.Name = '320110'

OR

[GL...