Regional Goal Set Formula Activity #7(201) Performance?

New Contributor

Regional Goal Set Formula Activity #7(201) Performance?

What are the performance implications writing the Company Percent formula as:

 

PY Sales / PY Sales.PY Sales[SELECT: 'Geos L1'.Total Company]

 

vs.

 

PY Sales / Company Goal Set.PY Sales

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Contributor

Re: Regional Goal Set Formula Activity #7(201) Performance?

The performance of the select should not be different if the G1 list is in the target module.

2 REPLIES
Highlighted
Super Contributor

Re: Regional Goal Set Formula Activity #7(201) Performance?

In this specific model? Probably nothing since it's so small and light. I suspect, however, that you're actually asking about the larger implications of using a SELECT function versus directly referencing. I'm going to add a few screenshots for the data in question and see if I can't get someone else to help answer.

Regular Contributor

Re: Regional Goal Set Formula Activity #7(201) Performance?

The performance of the select should not be different if the G1 list is in the target module.