Unfortunately, it’s incorrect as few entries are double-counted. I applied your workings to my file but I literally received the same result which is incorrect.
m code 2.xlsx (720.4 KB)
Excel Formula Total:
In the below file there is a total but also I did few calculations in order to get to 209,132,868.40
Please see Cell Y7 and Y9 sum of them give us the correct results
m code.xlsx (1.3 MB)
While I use your technique and mine I get 216,104,183.73
Transformation.pbix (537.6 KB)
Please let me explain what I want to achieve:
As in your file, I want to drill down period and month for each transaction but I need to exclude transactions that are:
- where the row line is with * in Alt account
Highlighted in yellow values equal to the green. I would like to keep values highlighted in green as they give an alt account also drill down period and dates.
The issue come in point 2
- Some of the values are in one line which would be perfect for us but there some values that have a split and total:
Once again I would like to show only value in green.
- Keeping any individual entries that are alone:
The issue comes when you need to differentiate between below transactions:
I need to have alt account as I would like to see allocation to each account and also do time intelligence measures.
In the file m code you will see a split for 27milion between each account but I can’t split the 181 million values with a *.
I tried many other techniques in excel but I always came to the same incorrect results.
I don’t know how I can get every individual line for values highlighted in green ensuring not to doublecount values or not to remove any single lines.
I will appreciate your help.
Thank you for your screenshots and all your hard work!