Forum Discussion
Augustas-ase
3 years agoHelper II
Formula
how to calculate and get percentages in a column?
Augustas-ase
3 years agoHelper II
all i get 100%
Augustas-ase
3 years agoHelper II
how to make, for example, that '2sale2s2' is calculated for each month 100% for each month, instead of for the whole year
- BIswajit_Das3 years agoImpactful Individual
Hello Augustas-ase, So you want the percentage to calculated by each month!!!
- Augustas-ase3 years agoHelper II
yes
- BIswajit_Das3 years agoImpactful Individual
You can do that by
Modify your formula to
calculate (expression,
filter(table,table[monthcol] = eariler(table[monthcol]))
)