Please see the attached
this is the formula
and it returns this (note I just included the values for ref)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
TableauCommunity1_v10.2.twbx 24.7 KB