2 Replies Latest reply on Aug 16, 2012 6:02 PM by TSADesign

    Trying to Set Field as Calculation of Global Field

    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