
Contributor III
2024-05-27
09:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ratio of the line-based calculation to the bottom sum
Hi everyone,
How can I get the addition ratio of the number I calculated next to the two dimension? I have two dimension on the left and on the right I want to divide by the sum of these digits.
Measure Formula: SUM({<[Flag]={"0"}>} Quantity)
Exp: 80803/1135617
I could not provide the display in the table for this rate calculation.
Thank you.
1 Solution
Accepted Solutions


MVP
2024-05-27
10:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This looks like it should be:
SUM({<[Flag]={"0"}>} Quantity) / SUM({<[Flag]={"0"}>} Total Quantity)
2 Replies


MVP
2024-05-27
10:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This looks like it should be:
SUM({<[Flag]={"0"}>} Quantity) / SUM({<[Flag]={"0"}>} Total Quantity)

Contributor III
2024-05-28
07:22 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you, total function never came to my mind 🙂
263 Views
