6 Replies Latest reply on Jul 17, 2017 7:34 PM by BlancheMcdade

    I Need a Formula to Evulate Data With Different Results

    BlancheMcdade

      Hi All,

       

      I need a formula to calculate the following data with specific results.

      Field 1 Has Subscription Periods

      Field 2 Results from the status of Field 1 GL Codes

       

      Subscription PeriodGL Codes
      FIRST_YEAR-ANNUAL Anguilla1300ANG
      FIRST_YEAR-ANNUAL TRS4440
      FIRST_YEAR-ANNUAL Preco4420
      FIRST_YEAR-ANNUAL4005CL1

       

      In the subscription period field, I could have 13 different locations for first FIRST_YEAR-ANNUAL subscriptions, with each having their own G/L code.

      Example:

      FIRST_YEAR-ANNUAL Anguilla

      FIRST_YEAR-ANNUAL Antigua

      FIRST_YEAR-ANNUAL Bermuda

       

      But where I am having the problem is making all the other records that don't have a specific GL code equal to 4005CL1.

      I have tried using Case and If statements.

       

      Please help or tell me which formula I should use.

       

      Thank you