Hi @Gabriel2020, I will try to help when I understand the question. I understand it is important to you, and I wish you well with your promotion but none of that is going to change what needs to be done, nor whether I can help you. You can start by uploading some sample data. Without that I can’t even guess.
The row of data you say is wrong is the first fully readable line in the screenshot. I need to know what data comes before it to even start.
I don’t work with your data and I don’t know your data.
I don’t remember it from 2 weeks ago except in vague terms.
Clarity of requirement is everything in this profession.
If I simply try to guess at a solution, and then you say it’s wrong again, we’ll go back in circles. This is why that last thread ran to over 60 posts. It wasn’t because the requirement was difficult, it is because you described it as if we would naturally understand your data. But you need to assume I know nothing about your data, because I don’t (as I think I wrote before!).
Back to my question… did the solution supplied in the other post, which was additionally refined by @iCFO here not calculate this correctly?: