AnsweredAssumed Answered

I Need a Formula to Evulate Data With Different Results

Question asked by BlancheMcdade on Jul 17, 2017
Latest reply on Jul 17, 2017 by 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

Outcomes