(COUNT(SELECT(Richieste[DATA],[PROCESSO]="Richiesta"))/[NUMERO TASK])/100
Could you tell me where Iโm wrong? Why is the result 0?
If I remove / 100 the calculation is correct. If I add / 100 the result is 0
Solved! Go to Solution.
Please take a look at the below peculiarity of the percent column type in AppSheet
[NUMERO TASK]=28
With the calculator 28/16 = 1.75
AppSheet
28/16 = 0
Unfortunately I still donโt understand. itโs a very simple calculation yet appsheet doesnโt return the correct result.
P.s.
This time I left the Types of both fields all set to number
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |