
1. Re: Percentage Calculation
Shinichiro Murakami Mar 7, 2016 6:21 PM (in response to jitan.chainani)1 of 1 people found this helpfulThis 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

2. Re: Percentage Calculation
jitan.chainani Mar 7, 2016 7:28 PM (in response to Shinichiro Murakami)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 Mar 7, 2016 7:48 PM (in response to Shinichiro Murakami)Could you attach excel as well to understand the expected results?
Still don't understand what is the problem.
Thanks,
Shin