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|
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.
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.