Level 2 Sprint 2 DEM03

LStinsa
Frequent Contributor

Level 2 Sprint 2 DEM03

I am in the process of adding DCA's to DEM03 and I was checking my work against the example and my % growth rate is too high.  It's at 14%.  I checked the formula and it looks correct to me.  I also checked my DEM02 model and it has the correct growth percentage rates in it.  Does anyone have any suggestions about where else I could look to correct this?

 

LStinsa_0-1615923782538.png

LStinsa_1-1615923823770.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Level 2 Sprint 2 DEM03

@LStinsa 

It's there. Just use your selector to go down to a sku level. With the summary off, you will not see any numbers at the aggregate levels.

Nice job!!


Jared Dolich

View solution in original post

9 REPLIES 9
JaredDolich
Moderator

Re: Level 2 Sprint 2 DEM03

@LStinsa 

Check the summary of that percentage. I suspect you have it as SUM. I think for this you can remove the summary.

Then drill down to a SKU and you'll see the right percentages. 

To get the percentage to aggregate correctly you'll have to create a weighted average which I think is out of scope for this course.


Jared Dolich
LStinsa
Frequent Contributor

Re: Level 2 Sprint 2 DEM03

@JaredDolich 

 

You are correct.  It should just pick up the number and not sum anything or average it.  When I drill down it looks like it is summing everything across all the SKU's.  How do you know if you should set things to none?  And do you set set the summary to none and the time summary to none?  

 

LStinsa_0-1615933651615.png

LStinsa_1-1615933674429.png

 

 

JaredDolich
Moderator

Re: Level 2 Sprint 2 DEM03

@LStinsa 

Yes, set both to none. But  you can just leave the time summary as the "same as lists". Percentages, Rates, and Ratios are always subject to this kind of issue so you have to ask yourself if you need to see the value at an aggregation. If you do, then you have to set up a method to recalculate it at that level. It's a little advanced for this course, especially since you're using a SUM and/or LOOKUP function. To aggregate you would have to create the separate line items that make up the percentage. One for the numerator, and one for the denominator. Then you would create the formula for the line item but change the summary to "formula" or "ratio". 

Good news is for this exercise you only need the percentage at the lowest level, so "None" is fine.


Jared Dolich
LStinsa
Frequent Contributor

Re: Level 2 Sprint 2 DEM03

I changed the summary but all of my data disappeared.  

 

LStinsa_0-1615936120299.png

 

LStinsa_1-1615936132800.png

 

JaredDolich
Moderator

Re: Level 2 Sprint 2 DEM03

@LStinsa 

It's there. Just use your selector to go down to a sku level. With the summary off, you will not see any numbers at the aggregate levels.

Nice job!!


Jared Dolich

View solution in original post

LStinsa
Frequent Contributor

Re: Level 2 Sprint 2 DEM03

@JaredDolich 

 

It was for the first SKU but it's not there for all of them.

 

LStinsa_0-1615937028946.png

 

JaredDolich
Moderator

Re: Level 2 Sprint 2 DEM03

@LStinsa 

It's a little tricky. The Bay Water Taffy is the Product, drill down to the SKU and you should see it.

Another way, which might be easier is to pivot your grid so the product is in the rows and the line items are columns. You should see all the SKUs have a percentage.

Give it one more try, you got this!


Jared Dolich
LStinsa
Frequent Contributor

Re: Level 2 Sprint 2 DEM03

Got it!  Thank you for your help.

 

Leah

JaredDolich
Moderator

Re: Level 2 Sprint 2 DEM03

@LStinsa Leah!

You rock! That's awesome.


Jared Dolich