2 Replies Latest reply on Sep 6, 2016 5:57 AM by Bianca Reddick

    Month Over Month

    Bianca Reddick

      Hello,

       

      I have some data in which I am trying to do a month over month calculation as well as determine the forecast vs actuals month over month. I have attached a sample data set if someone could please help.

       

      Thank you,

       

      Bianca

        • 1. Re: Month Over Month
          Shinichiro Murakami

          I created something , but this should not be the final answer, I believe.

          I need more detailed info to understand your request.

           

           

          So far I did below,

           

           

          [ACTUAL]

          if [Type]="Actuals" then [Amount]end

           

          [FCST]

          if [Type]="Forecast" then [Amount]end

           

          [Actual/FCST]

          zn(sum([ACTUAL])/sum([FCST]))

           

           

           

          Thanks,

          Shin

          1 of 1 people found this helpful
          • 2. Re: Month Over Month
            Bianca Reddick

            Thank you this helped with the month over month. I have created multiple different dashboards, but struggle with the different calculations. What is the reason for using the zn function when adding and dividing measures? I had originally did the first two calculations you provided and then tried to create a calculation as actuals + forecast and actuals/forecast and it left me with 0.

             

            The other issue I am facing is the FY Forecast is summing together unless I put the months in there to break it out so I am unable to use pie charts. Do you know a work around for this?