Level 3-Sprint 1-Tar01: PY Account/PY Country Product Family %

Highlighted
Occasional Contributor

Level 3-Sprint 1-Tar01: PY Account/PY Country Product Family %

I am able to have the correctly summed PY Country and Product Family sales roll into the PY Account revenue but my % don't add up to 100% in the check module.  They are about 3-5X higher.  I have validated all input data but can't seem to get them to only add to 100%.  Any help would be appreciated.

 

 

Capture_2.PNGCapture.PNG

5 REPLIES 5
Highlighted
Regular Contributor

Re: Level 3-Sprint 1-Tar01: PY Account/PY Country Product Family %

Hi @mEEhan011 

 

I had faced the same issue.

Recheck your Sum% formula.

 

~Abhi

Highlighted
Occasional Contributor

Re: Level 3-Sprint 1-Tar01: PY Account/PY Country Product Family %

@abhi1017 

 

I'm already summing by the Country and Product Family in the check module.  With those as the only dimensions other than time, which is constant between the two modules, I can't think of anything else. Is there something else I need to add? 

Highlighted
Regular Contributor

Re: Level 3-Sprint 1-Tar01: PY Account/PY Country Product Family %

Hi @mEEhan011 

 

Relook at TAR01 module, PY Account revenue and PY Country & Product family sales need formula tweaks.

 

If you are not able to configure, pls share a screenshot of blueprint view of TAR01.

 

 

~Abhi

Highlighted
Occasional Contributor

Re: Level 3-Sprint 1-Tar01: PY Account/PY Country Product Family %

Hi @abhi1017 

 

Capture_3.PNG

 

 

Highlighted
Regular Contributor

Re: Level 3-Sprint 1-Tar01: PY Account/PY Country Product Family %

1. Country - fine

2. P1 Product Family - fine

3. PY Country and Product Family Sales-  Relook on this (Lookup and SUM functions to be used)

4. Initial Country Sales Target :- Seems fine

5. PY Account Revenue :- Relook at this formula (Lookup needs to be changed)

6. PY account/PY Country Product Family:- Seems you need to Interchange numerator and denominator

7. Inital Account Sales Target :- Its an increase that can be found from (PY Country and Product Family Sales) and (PY account/PY Country Product Family) not % Increase.

 

Hope this helps

~Abhi