3 Replies Latest reply on Mar 7, 2016 7:28 PM by jitan.chainani

    Percentage Calculation

    jitan.chainani

      Hi Guys,

       

      In the screen shot below I am trying to calculate the projected amount based of the Avg. Projections for New Release. The results are different when I do the same calculation in excel.. I am not able to figure out what is the reason and would need your suggestion.

       

      Below is the formula I am using to calculate projected amount 1 =

      If [Week]='Week 1' Then ([Estimate]*[Projections for New Release])

      ELSEIF [Week] = 'Week 2' Then [Estimate] * [Projections for New Release]

      END

       

      Estimate is also a calculated field. I am not sure if that's causing this problem.

       

      Any suggestions will be very helpful.

       

        • 1. Re: Percentage Calculation
          Shinichiro Murakami

          This formula brings same result for both Week1 and Week2.

          Need to see actual data structure to understand what is the expected result.

           

          If [Week]='Week 1' Then ([Estimate]*[Projections for New Release])

          ELSEIF [Week] = 'Week 2' Then [Estimate] * [Projections for New Release]

          END

           

          Could you share the packaged workbook or excel at least for us to investigate more?

           

          Thanks,

          Shin

          1 of 1 people found this helpful
          • 2. Re: Percentage Calculation
            jitan.chainani

            Hi Shin,

             

            Thanks for your help!

             

            Attached is the work book for your reference. Please let me know if my projected amount calculation is wrong.

             

            The tab i am working on is projection old.

             

            One more request - There is a input parameter to update estimates by users if they do not like the generated one. This is happening across all countries and I am looking for something where user can input for a specific country and the rest they use from generated calculations.

             

            Thanks again,

            JC

            • 3. Re: Percentage Calculation
              Shinichiro Murakami

              Could you attach excel as well to understand  the expected results?

              Still don't understand what is the problem.

               

              Thanks,

              Shin