level 3 tar01 - initial acc sales target

RavinderB
RavinderB
in Modeling

Hi

 

clarificiation - I used

 

'TAR00 Sales Targets'.Initial Country Sales Target * 'PY Account / PY Country Product Family'

 

I see these results

 

Screenshot 2022-02-15 at 10.47.07.png

 

the total for candygate relates to learning center screen :

 

jfafEnA6t9a0CXZ1__WJ1h0Zbml7IvaAJ.png

 

 

the problem is the formula totals everything for all accounts; so i feel it is incorrect and requires an edit - lookup

 

‘PY Account / PY Country Product Family’ * ‘TAR00 Sales Targets’.Initial Country Sales Target[LOOKUP: ‘SYS03 Account>Product Details’.‘G2 Country’, LOOKUP: ‘SYS03 Account>Product Details’.‘P1 Product Family’, LOOKUP: ‘SYS03 Account>Product Details’.‘A1 Account’]
 
but this fails on A1 account
not sure why it is failing here
 
please advise 
Tagged:

Answers

  • RavinderB
    RavinderB

    If you see this pivot view from above; my totals do match for candygate; but this is repeated for other accounts also.

     

    My numbers for products in accs is different ccompared to check build screenshot.

     

    please advise

     

    Screenshot 2022-02-15 at 14.18.19.png

Categories