Percent Calculation not calculating, returning 0

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

ZOCO_Unlimited_0-1704060184429.png

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]))

ZOCO_Unlimited_1-1704060650996.png

 

 

 

Solved Solved
0 6 882
1 ACCEPTED SOLUTION

You need to add 1.0 with your calculation like.. SUM([Related Stops][Complete Counter])/(1.0*COUNT([Related Stops]))

View solution in original post

6 REPLIES 6