I have a massive calculation, It basically matches one field with the other when a code is entered. It now tells me that I have too many seperations when I add more to the CASE. Does anyone know if I have reached my limit? And if I have is their any other way to enter more info?

Please help?

Also I have indexed feilds that will have numbers in them and i need the to total up in another field. I can only get the first number of the Indexed field to total up.

how can make it so all the numbers total up?

quote:

---

Originally posted by Chuck:

I've usually gotten such a message with a Case statement when there was a comma after the last argument. It other words, my Case statement looks like this:

Case( A = B, 1, 2, )

There's an extra comma after the 2, but there's not default answer.

If this isn't what's happening, then perhaps there is a limit to the number of arguments in a Case statement. I've never heard of that being the case, but perhaps you've reached that limit.

If that's the case, see what you can do about breaking up the calculation into two calcs.

For instance, let's say your calc is like this:

Case( A = 1, X, A = 2, Y, A = 3, Z )

You could break this into two calcs like this:

Calc 1 = Case( A = 1, X, A = 2, Y )

Calc 2 = Case( Calc 1 = X or Calc 1 = Y, Calc 1, A = 3, Z )

Calc 2 will have the same results as your original calc. It's going to make for a heinous set of calculations, but if you've reached a limit on arguments, it would work.

Chuck

---

I am really having problems understanding this.

I my calc goes more like this:

Case(

fall even Year = "AD1"," LAYOUT 1",

fall even Year = "AD11","NEW BUSINESS/PRESENT",

fall even Year = "AD12","GOBAL ADVERTISING",

fall even Year = "AD15","ADVANCED CAMPAIGNS",

fall even Year = "AD17","TV CONCEPTS 3",

fall even Year = "AD19","TV CONCEPTS 4",

fall even Year = "AD2","BRANDS & BRANDING",

fall even Year = "AD21

First of all, did you check for the extra comma at the end of the arguments?

Now, let's say that field 1 is your example calculation and is set to be a text result:

Case(

fall even Year = "AD1"," LAYOUT 1",

fall even Year = "AD11","NEW BUSINESS/PRESENT",

fall even Year = "AD12","GOBAL ADVERTISING",

fall even Year = "AD15","ADVANCED CAMPAIGNS",

fall even Year = "AD17","TV CONCEPTS 3",

fall even Year = "AD19","TV CONCEPTS 4",

fall even Year = "AD2","BRANDS & BRANDING",

fall even Year = "AD21

I've usually gotten such a message with a Case statement when there was a comma after the last argument. It other words, my Case statement looks like this:

Case( A = B, 1, 2, )

There's an extra comma after the 2, but there's not default answer.

If this isn't what's happening, then perhaps there is a limit to the number of arguments in a Case statement. I've never heard of that being the case, but perhaps you've reached that limit.

If that's the case, see what you can do about breaking up the calculation into two calcs.

For instance, let's say your calc is like this:

Case( A = 1, X, A = 2, Y, A = 3, Z )

You could break this into two calcs like this:

Calc 1 = Case( A = 1, X, A = 2, Y )

Calc 2 = Case( Calc 1 = X or Calc 1 = Y, Calc 1, A = 3, Z )

Calc 2 will have the same results as your original calc. It's going to make for a heinous set of calculations, but if you've reached a limit on arguments, it would work.

Chuck