topic Percentage Calculation in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76331#M15869
<P>Hi All,</P><P> </P><P>I am facing an issue in the calculation of percentages at summary level.I have a module where I have a percentage calculation field where the percentages are calculated and are imported to another line item from there in the same module. As the second line item displays the option of user inputting the value under one of the headers but displays the calculated imported values under the other headers.</P><P> </P><P>So the summary option of the 2nd line item where data is imported and is input by the user is kept as ratio to display the correct values at summary. This is because the summary level calculations of percentages is not imported.However the summary level calculation is not coming out to be correct the formula used in ratio summary is of (volume of each child(brand)/ Volume of its parent(segment)).</P><P> </P><P>For all the particular brands the summary calculation is correct at an all country level, at all channel level. But the percentage calculation of the segments i.e. of the parents is coming incorrect as the denominator calculation tends to add up for all the respective brand i.e. diving each segment value by 5 times of its sum if 5 brands lie under it.Therefore the resultant value is never coming to be 100%.</P><P> </P><P>I have attached the images for your reference. Requesting your help on this as this is very crucial.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denominato(market share% for lookup) .JPG" style="width: 999px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/35752i8E139CBD42A016FA/image-size/large?v=v2&px=999" role="button" title="Denominato(market share% for lookup) .JPG" alt="Denominato(market share% for lookup) .JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Formula For Ratio.JPG" style="width: 999px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/35753i48951BB91A0B0E7C/image-size/large?v=v2&px=999" role="button" title="Formula For Ratio.JPG" alt="Formula For Ratio.JPG" /></span> FYI: The first Market share% is the line item from which the values are imported to market share% line item which has no formula at the most granular level and are coming correct. The market share% for lookup is the denominator in the ratio which is coming to be incorrect at SB1 segment level (which is the parent of SB2 Segment Brand child list) however the calculations for SB2 Segment brand are coming to be correct at any of the summary levels.</P><P> </P><P>Please help me resolve this to get answers at parent level also</P><P> </P><P>Thanks</P>Wed, 08 Jul 2020 07:32:42 GMTCommunityMember1313572020-07-08T07:32:42ZPercentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76331#M15869
<P>Hi All,</P><P> </P><P>I am facing an issue in the calculation of percentages at summary level.I have a module where I have a percentage calculation field where the percentages are calculated and are imported to another line item from there in the same module. As the second line item displays the option of user inputting the value under one of the headers but displays the calculated imported values under the other headers.</P><P> </P><P>So the summary option of the 2nd line item where data is imported and is input by the user is kept as ratio to display the correct values at summary. This is because the summary level calculations of percentages is not imported.However the summary level calculation is not coming out to be correct the formula used in ratio summary is of (volume of each child(brand)/ Volume of its parent(segment)).</P><P> </P><P>For all the particular brands the summary calculation is correct at an all country level, at all channel level. But the percentage calculation of the segments i.e. of the parents is coming incorrect as the denominator calculation tends to add up for all the respective brand i.e. diving each segment value by 5 times of its sum if 5 brands lie under it.Therefore the resultant value is never coming to be 100%.</P><P> </P><P>I have attached the images for your reference. Requesting your help on this as this is very crucial.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denominato(market share% for lookup) .JPG" style="width: 999px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/35752i8E139CBD42A016FA/image-size/large?v=v2&px=999" role="button" title="Denominato(market share% for lookup) .JPG" alt="Denominato(market share% for lookup) .JPG" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Formula For Ratio.JPG" style="width: 999px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/35753i48951BB91A0B0E7C/image-size/large?v=v2&px=999" role="button" title="Formula For Ratio.JPG" alt="Formula For Ratio.JPG" /></span> FYI: The first Market share% is the line item from which the values are imported to market share% line item which has no formula at the most granular level and are coming correct. The market share% for lookup is the denominator in the ratio which is coming to be incorrect at SB1 segment level (which is the parent of SB2 Segment Brand child list) however the calculations for SB2 Segment brand are coming to be correct at any of the summary levels.</P><P> </P><P>Please help me resolve this to get answers at parent level also</P><P> </P><P>Thanks</P>Wed, 08 Jul 2020 07:32:42 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76331#M15869CommunityMember1313572020-07-08T07:32:42ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76335#M15873
<P><LI-USER uid="24192"></LI-USER> </P><P> </P><P>That can be because your Summary is kept at SUM for both Num and Denom. Can you just create a simple calcs in excel or in anaplan and show what is incorrect figure and what is expected outcome so that it will help us to recreate and get you close towards the solution.</P>Wed, 08 Jul 2020 08:26:22 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76335#M15873Misbah2020-07-08T08:26:22ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76337#M15874
if you need different summary calculations for the different dimensions, you are going to have to detect the dim&level inside the formula and use the Formula summary type.<BR /><BR />For example: IF low level then data else if SummaryOfThisDIm then this formula else that formula<BR /><BR />it's a bit complex but it does workWed, 08 Jul 2020 08:37:45 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76337#M15874nathan_rudman2020-07-08T08:37:45ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76340#M15875
<P>Hi <LI-USER uid="9355"></LI-USER> </P><P> </P><P>The calculations are suppose to be as follows:</P><TABLE width="128"><TBODY><TR><TD width="63.2px" height="29px">SB1 </TD><TD width="64px" height="29px">Values</TD></TR><TR><TD width="63.2px" height="29px">A</TD><TD width="64px" height="29px">200</TD></TR><TR><TD width="63.2px" height="29px">B</TD><TD width="64px" height="29px">300</TD></TR><TR><TD width="63.2px" height="29px">C</TD><TD width="64px" height="29px">400</TD></TR></TBODY></TABLE><TABLE width="370"><TBODY><TR><TD width="64"> </TD><TD width="64">SB2</TD><TD width="64">values</TD><TD width="64">Value of A</TD><TD width="114">market share%</TD></TR><TR><TD>child of A</TD><TD>D</TD><TD>50</TD><TD>200</TD><TD>25%</TD></TR><TR><TD>child of A</TD><TD>E</TD><TD>50</TD><TD>200</TD><TD>25%</TD></TR><TR><TD>child of A</TD><TD>F</TD><TD>50</TD><TD>200</TD><TD>25%</TD></TR><TR><TD>parent</TD><TD>A</TD><TD>200</TD><TD>200</TD><TD>100%</TD></TR></TBODY></TABLE><P> </P><P>However in Anaplan when I am performing this calculation, the percentages are being calculated correctly for all the child list items but not for the parent SB1 market share%. The reason being is that numerator calculations are correct but however when the denominator calculation is concerned for the parent it is taking sum of all parent values of the brands i.e dividing 200 by 600 as shown below:</P><P> </P><TABLE width="456"><TBODY><TR><TD width="64"> </TD><TD width="64">SB2</TD><TD width="64">values</TD><TD width="64">Value of A</TD><TD width="200">market share% in Anaplan </TD></TR><TR><TD>child of A</TD><TD>D</TD><TD>50</TD><TD>200</TD><TD>25%</TD></TR><TR><TD>child of A</TD><TD>E</TD><TD>50</TD><TD>200</TD><TD>25%</TD></TR><TR><TD>child of A</TD><TD>F</TD><TD>50</TD><TD>200</TD><TD>25%</TD></TR><TR><TD>parent</TD><TD>A</TD><TD>200</TD><TD>600</TD><TD>33%</TD></TR></TBODY></TABLE><P> </P><P>I want to restrict the summary of denominator to formula instead of sum but I am not being able to due to the presence of lookup.</P><P> </P><P>I'll be really thankful to you if you could help me resolve this or provide me an alternative solution for the same.</P>Wed, 08 Jul 2020 09:16:31 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76340#M15875CommunityMember1313572020-07-08T09:16:31ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76341#M15876
Hi<BR /><BR /><LI-USER uid="400" login="nathan_rudman"></LI-USER>,<BR /><BR />Can you please help me understand on how to apply formula to summary. I am not being able to execute it.<BR /><BR />Thanks in advance.Wed, 08 Jul 2020 09:17:51 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76341#M15876CommunityMember1313572020-07-08T09:17:51ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76342#M15877
<P><LI-USER uid="24192"></LI-USER> </P><P> </P><P>you just need to select 'Formula' as you summary method</P>Wed, 08 Jul 2020 09:29:55 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76342#M15877filip.sypniewski2020-07-08T09:29:55ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76343#M15878
How do I do that my denominator has lookup in the formula<BR />Wed, 08 Jul 2020 09:56:13 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76343#M15878CommunityMember1313572020-07-08T09:56:13ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76347#M15879
<P><LI-USER uid="24192"></LI-USER> </P><P> </P><P>See if this helps</P><P> </P><P>1. Create another line item with a subsidiary view (Having Parent as a dimension, in your case it is segment)</P><P>2. Pull the values directly from the source module without using LOOKUP</P><P>3. Now use Ratio in your summary - Values/Value without LOOKUP</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Misbah_0-1594202542095.png" style="width: 400px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/35756i47FE9EAD70D53609/image-size/medium?v=v2&px=400" role="button" title="Misbah_0-1594202542095.png" alt="Misbah_0-1594202542095.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Misbah_1-1594202557198.png" style="width: 400px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/35757i8650C516FFF63066/image-size/medium?v=v2&px=400" role="button" title="Misbah_1-1594202557198.png" alt="Misbah_1-1594202557198.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Misbah_2-1594202575724.png" style="width: 400px;"><img src="https://community.anaplan.com/t5/image/serverpage/image-id/35758i28F9501BB53EF448/image-size/medium?v=v2&px=400" role="button" title="Misbah_2-1594202575724.png" alt="Misbah_2-1594202575724.png" /></span></P><P> </P>Wed, 08 Jul 2020 10:04:15 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76347#M15879Misbah2020-07-08T10:04:15ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76348#M15880
<P>From your example, it is always Value of A / Value of A, is it not 100% always at summary level.</P><P> </P><P>Or the example is not suitable for this..</P><P> </P><P>Thanks</P><P>Arun</P>Wed, 08 Jul 2020 10:24:59 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76348#M15880ArunManickam2020-07-08T10:24:59ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76354#M15882
<P><LI-USER uid="9355"></LI-USER>, Whenever I am trying to apply I am getting an error of dimension mismatch while applying this as ratio formula.</P><P> </P>Wed, 08 Jul 2020 10:40:57 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76354#M15882CommunityMember1313572020-07-08T10:40:57ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76355#M15883
<P><LI-USER uid="24192"></LI-USER> </P><P> </P><P>What are the dimensions that you are using for the line item "Market Share % Lookup". You just have to replace Brand with segment keeping rest of the dimensions same if they are to be taken into consideration.</P>Wed, 08 Jul 2020 10:41:21 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76355#M15883Misbah2020-07-08T10:41:21ZRe: Percentage Calculation
https://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76356#M15884
<LI-USER uid="9355" login="Misbah"></LI-USER> Yes I have done that the dimensions for market share% lookup are brands, channel,rate area and a customised list header.<BR /><BR />For the calculation of denominator I have created another line item with dimension as segment,rate area,channel and list headers.<BR />But as soon as in ratio formula I applying it I am repeatedly getting the error of dimension mismatch as the numerator values are coming at brand level but denominator at segment level.Wed, 08 Jul 2020 11:17:48 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Percentage-Calculation/m-p/76356#M15884CommunityMember1313572020-07-08T11:17:48Z