see the attached - min
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.
Thanks for your solution, but this does not solve our current issue.
While I understood your approach, the solution makes a brand family a base parameter and the other price gaps are calculated by only that one.
The workaround we are looking is for the prices to calculate the gap based on the next price below it, without considering the brand family.
That way when brands change price segment it will automatically calculate it, and not based on brand family per se.