This is the closest I could get to it. I think there’s a minor mistake in my manual calculation when I posted this. So there are two rows that differ with the “expected outcome”.
Unlike the other related post of mine which was based on real-world case, this one was a conceptual exercise, so there’s no real world dataset to test the results on. Proceed with caution.
Here’s the workflow “solution” : Clash of the pirates.knwf (262.7 KB)
Moving on to new things.