IF(
[Pair types] = "used pair",
([Quantity] / SUM(SELECT(scan sheet [Quantity], [Pair types] = "used pair"))) * 100,
0
)
Percentage calculation showing "0"
Solved! Go to Solution.
Please take a look at the below tip by @Steve
Fix for expression giving 0% or missing decimal pa... - Google Cloud Community
User | Count |
---|---|
33 | |
25 | |
22 | |
21 | |
15 |