Level 3 Sprint 1 9.3 small differences

lramirezcortes
lramirezcortes
in Academy Discussions

I have reviewed each step and I dont really know how to get the number of the example… here i have the example given:

image.png

and here my results after each formula…

image.png

I have used the next formulas:

  • Percentage %: Initial Account Sales Target / Initial Account Sales Target[LOOKUP: 'SYS99 Lookups'.Target Year]
  • Initial Account Sales Target: 'TAR01 Detailed Sales Targets'.Initial Account Sales Target
  • Final Account Sales Target: 'TAR02 Account Review'.Final Sales Targets[LOOKUP: 'SYS99 Lookups'.Target Year] * Percentage %

Can someone help me please… i have checked all the steps and i can not get the correct result…

Thank you!

Best Answer

  • Dikshant
    Dikshant
    Answer ✓

    Try to use this logic and check.

    Percentage:

    'DAT02 PY Revenue to CY'.'FY19 Quarterly Sales Revenue' / 'DAT02 PY Revenue to CY'.'FY19 Quarterly Sales Revenue'[LOOKUP: 'SYS99 Lookups'.Target Year]

    Initial Account Sales Target:

    'TAR02 Account Review'.Initial Account Sales Targets[LOOKUP: 'SYS99 Lookups'.Target Year] * % of Account Sales Target

Answers

Categories