Hi, yes managed to find the solution here in this https://community.amazonquicksight.com/t/level-aware-sum-sumover-problem/13982/25 and changed my formula to this:
sum(min({avg_price_over_object_date},[{DATE}, {TYPE}, {NAME}]))
1 Like