To get the correct results with blending,
one should stay at the VizLOD of the blended fields --
using Table Calculations / Filters on top of that.
Besides, a straightforward approach is
to join the List Price table.
Please find the attached as an example.
Avg_Discount_v10.2_YF.twbx 2.7 MB