Divide number not working
I used sum function to get the total number and using the Simple formula in Calculated Field to get the percentage value. However, it returns 0.
the Formula is "SUM ( A_COUNT ) / SUM ( Total Number of All working )"
The Total Number of working contains 0, so I also tried using the Formula
"CASE WHEN Total Number of All working != 0 THEN A_COUNT / Total Number of All working END", but still not correct?
So how can I get the right value for Number of A / Total Number of working?
The Yellowfin version is 18.104.22.168, and the Build is 20211215