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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 114 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 770 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 76 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive