Sum of all Subtotal of separate item isn't equal to Total number

I made a beast mode as below.
CASE
WHEN SUM(CASE WHEN Region_TWC
IN ('NAM','EUROPE','PACIFIC','JAPAN','KOREA','GCA','SEA') AND PO Type
IN ('Sample','Demo','SF','M0','M1') AND Meet FOB DL_AR
= 'Meet AR DL' THEN Ordered unit
END)
>= SUM(DISTINCT PAR in PQ
)
THEN SUM(DISTINCT PAR in PQ
)
WHEN SUM(CASE WHEN Region_TWC
IN ('NAM','EUROPE','PACIFIC','JAPAN','KOREA','GCA','SEA') AND PO Type
IN ('Sample','Demo','SF','M0','M1') AND Meet FOB DL_AR
= 'Meet AR DL' THEN Ordered unit
END)
< SUM(DISTINCT PAR in PQ
)
THEN SUM(CASE
WHEN Region_TWC
IN ('NAM','EUROPE','PACIFIC','JAPAN','KOREA','GCA','SEA') AND PO Type
IN ('Sample','Demo','SF','M0','M1') AND Meet FOB DL_AR
= 'Meet AR DL' THEN Ordered unit
END)
END
When run the chart by regions by a specific project in my dataset, the Sum of subtotal of each region isn't equal to Total number.
Ex. Sum of subtotal of each region is 34k.
However, when use project total, the total qty is 42k.
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 483 APIs & Domo Developer
- 88 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive