hi guys, i need to count one column but i need the result as percentage.
the column that i need to count is [disponibilidade] and i need to count if it = “parcial”
so i did with virtual column and in app formula:
Count(select(visao[disponibilidade],[disponibilidade]=“parcial”)
)
but i need to get the result as percentage from the total “358”
so if the count is 11 the result must be 3% (11*100/358)
is there anyway to do the calc with the Count appformula above?
because i need 3 percentages so if i do the calc separated i will need 6 virtual column instead 3.
You could change it to percent column and then use…
Count(select(visao[disponibilidade],[disponibilidade]=“parcial”)
)/
Count(visao[disponibilidade])
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |