Calculated: sumproduct field doesn't take all options from dropdown filter

I created 2 text elements:

  1. Order Count which is simple sum of all order quantity, based on Region constraints – Dropdowns value (example option USA, MX)
  2. Order Value which is SUMPRODUCT of quantity list and price list, based on Region contrainst – dropdown value (example option USA, MX)

Problem:

  1. When dropdown value is NOT selected … meaning ALL options are selected, Order Count is showing values correctly for ALL Options
  2. But Order Value which is based on Sumproduct doesn’t show values until an option is selected in the dropdown filter. Meaning it doesn’t calculate for ALL options

Ps: for Region option values… i use Option Set.

Can you help why am i not getting for ALL options in Sumproduct? And how i can resolve it

Screenshots:

This topic was automatically closed after 70 days. New replies are no longer allowed.