I have a list with Material, Batch, Quanity, posting date.
User wanted to see only the last line of the posting date.
I did this with a ranking on posting date and then apply a filter to the report only showing the 1’s.
Works just fine.
Now the user wants to see the Quantities for all the posting dates by Material/Batch combi (I made a key that adds material and batch together).
So like a YTD quantity.
I easily fixed that with this formula:
Also that worked just fine…untill I put back my filter.
The amounts were wrong.
Tried fixing with:
But no luck.
Anybody know the solution?
rpinxt (BOB member since 2019-01-23)