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

# Percentage Calculation

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

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

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

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

Still don't understand what is the problem.

Thanks,

Shin