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
I have a data table with daily cash balances that I would like to present in quarterly, monthly, and year values in a visual. BI will add the daily amounts which I include my cash column in a visual. I am sure somebody has answered my question but I am not figuring it out.
