AnsweredAssumed Answered

Trying to Set Field as Calculation of Global Field

Question asked by TSADesign on Aug 16, 2012
Latest reply on Aug 16, 2012 by TSADesign

Title

Trying to Set Field as Calculation of Global Field

Post

In the following script I am trying to perform a find based upon the contents of Field 1 being less than my global gField 2. This is to select all account that have sales less than a global field with a drop down list of values (1000...50000). The idea would be for a manager to be able to select all accounts with sales ≤ X and a sales rep = Y.

Unfortunately when I execute the script, I get a returned value of no records, however if I were to go into Find mode and physically select a sales rep from the sales rep field, and set ≤X in the sales field I would get the desired results.

I would appreciate any help.

Thank you.

 

 

Screen_Shot_2012-08-16_at_5.41.35_PM.jpg

Outcomes