Our accounting system has an account code of five digits (specified as a text column).
I am creating a summary P & L account which we call a Group Ten Summary e.g. account codes between 10000 to 10009 are added together under group 1000.
I have attached the pbix file and if you look at the Summary P/L & B/S tab you will see the summary. Every group total work absolutely fine except the first Income group 0000.
If you look at the second tab (Profit & Loss) you will see the three income codes that comprise the group 0000 (00001, 00002, 00003) are there.
The group summary calculation is performed by a measure “Total Group Ten” in the Profit and Loss Measures section.
I am at a complete loss to understand why this is not working.
Any help greatly appreciated.
Accounts.pbix (1.2 MB)