I need to retrieve a decimal or a percent of a job complete. Every way I've written this, I keep ending up with 0. Any ideas?
Jobs Table, Job Status Percent Column: SUM([Related Stops][Complete Counter])/COUNT([Related Stops])
I also tried it directly in the Stops table and it results in 0 as well so I'm assuming it's something in how I'm writing the expressions
Stops Table: COUNT(Select(Stops[Stop ID],AND([Job ID]=[_THISROW].[Job ID],[Status]=Complete)))/
COUNT(Select(Stops[Stop ID],[Job ID]=[_THISROW].[Job ID]))
Solved! Go to Solution.
You need to add 1.0 with your calculation like.. SUM([Related Stops][Complete Counter])/(1.0*COUNT([Related Stops]))
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |