Thanks for your help in advance!
I was following the Balance Sheet template example and often the financials prepared have similar names in both Current and Non Current. Given the Switch statements look for the text name in the template you cant have for example Inventory in Current and Non Current sections as it will repeat.
Has anyone worked out a way to make this work?
I have attached an example where I have added the switch statement for the current assets but as you can see if the name is the same it will obviously repeat in both Current and Non Current section if text name is the same.
Unfortunately, in the raw data there is no account type dimension that specifies what is current and non current account but the numbering is used by the client to indicate this as follows:
1-1000 to 1-4999 is Current
1-5000 to 1-9999 is Non Current
Here is the image for review