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

    Month Over Month

    Bianca Reddick



      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,



        • 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,




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



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









          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?