Forum Discussion

Augustas-ase's avatar
Augustas-ase
Icon for Helper II rankHelper II
3 years ago

Formula

how to calculate and get percentages in a column?  
Need Help
Augustas-ase's avatar
Augustas-ase
Icon for Helper II rankHelper II
3 years ago

all i get 100%

 

Augustas-ase's avatar
Augustas-ase
Icon for Helper II rankHelper II
3 years ago

how to make, for example, that '2sale2s2' is calculated for each month 100% for each month, instead of for the whole year

 

  • BIswajit_Das's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Hello Augustas-ase, So you want the percentage to calculated by each month!!!

    • Augustas-ase's avatar
      Augustas-ase
      Icon for Helper II rankHelper II
      3 years ago

      yes

      • BIswajit_Das's avatar
        BIswajit_Das
        Icon for Impactful Individual rankImpactful Individual
        3 years ago

        You can do that by
        Modify your formula to
        calculate (

        expression,
        filter(table,table[monthcol] = eariler(table[monthcol]))
        )