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 Period | GL Codes |
---|---|

FIRST_YEAR-ANNUAL Anguilla | 1300ANG |

FIRST_YEAR-ANNUAL TRS | 4440 |

FIRST_YEAR-ANNUAL Preco | 4420 |

FIRST_YEAR-ANNUAL | 4005CL1 |

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

I am assuming that each row is a different record.

Using Case:

Case (

Field 1 = "

FIRST_YEAR-ANNUAL Anguilla" ; "1300ANG" ;Field 1 = "FIRST_YEAR-ANNUAL TRS" ; "4440" ;Field 1 = "FIRST_YEAR-ANNUAL Preco" ; "4420" ;"4005CL1")A better option would be to use the Looked Up Value option to look up these codes from a related table so that you can edit this list without having to redefine a calculation. There's an option to specify a value if there is no exact match where you can enter:4005CL1.