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?