Need to use annual amount in a formula but comparing it to a monthly amount in same module?
I have a requirement to show the following:
annual quota * multiplier = target
then compare month orders to this target and see if the person exceeded the target.
I have a module at a monthly level, and if you go down to the Quarter or monthly level, the quota keeps changing, i need this amount to remain static, and let the order amounts change based on the month or quarter selected. Is this possible in one module?