6 Replies Latest reply on Jan 28, 2014 9:47 AM by Craig Mullins

    I need a calculated field to annualize data based on frequency

    Craig Mullins

      Screen Shot 2014-01-27 at 12.03.57 PM.png

      i need a calculated field to annualize each row based on the dimension "Freq".

       

      for example:

      • weekly would be 16648 x 52 weeks per year = 865696
      • bi-weekly would be 2963 x 26 bi-weekly periods per year = 77038
      • etc

       

      it should be a simple formula but i cannot seem to get the formula below to work.

       

      IF [Freq]="Weekly" then [Amount] *52 else

      IF [Freq]="Bi-Weekly" then [Amount] *26 else

      IF [Freq]="Monthly" then [Amount] *12 else

      IF [Freq]="Quarterly" then [Amount] *4 else

      IF [Freq]="Annually" then [Amount] *1 else

      end

       

      can anyone tell me where i am off?

      thanks