Level 3 Sprint 1 - Section 9:2

Options
maheswariJ
maheswariJ Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Anaplan Community

Hi,

 

We need to distribute the Final Account sales target to quarters by reflecting the proportionality of the Initial Account Sales Targets distribution in Quarters.

 

So to find the percentage of Initial Account Sales Targets distribution in Quarters, we need to lookup at the Quarterly value and divide it by FY 20 value. As part of hint or idea, its been suggested to use LOOKUP function and the SYS99 Lookup module, rather than using a SELECT function. 

Why cant I use Yearvalue function? Is there any specific reason that we have to use SYS99 module?

 
 

 

Tagged:

Comments

  • maheswariJ
    maheswariJ Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Occasional Contributor
    Completely agree with your point but my question is why there is a hint in training to use that particular system model and Lookup. Is it necessary to go as per hint if i can derive the same value using Yearvalue function.

Categories