Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Re: Rangesum - Running Balance by Dimension
The link above gave me great help to get my running balance working but when i went to validate, there are 3-4 groupings where the balance "loses its way" - See yellow highlight on Attached Excel
As you can see from the attached QVW, 99.5% of the balances are tracking perfectly except for 3-4 items where it calculates perfect then in the middle, the calculation seems to just "reset". Odd thing is when I drill into those records (by dates 5/24/16 & 5/25/16, the running balances work.
Another balance error is in Warehouse 120
In the QVW there is a Bookmark for the Drill Down
Transaction Date is a dimension like any other... above(total) is just the line above ... not more not less
Off course you try to find a lucid explanation... but I still think there isn't one...
This was confirmed to be a bug in 11.2 SR15
Tech Support said they opened my document in 12.x and it worked.
Thanks for your feedback!