I'm doing a fairly complex formula that sets the price for lots in our inventory, the price depends on a number of variables such as size , type, location etc. I'm using the case funtion and a bunch of global fields by which to compare, and the formula extends to about four pages long, at the end of about the first page I get the message : "too many separators", I've looked for errors and I couldn't find any so my assumption is that perhaps there is a limit on the size that a formula can be ? is there any ? or do I have to look harder at my formula.

Thank You

First, I believe that there is in fact a maximum size to a calculation, although exactly what it is I've never checked to see. I have created calculations that were very large and produces errors. My workaround for this was to break the calc into multiple calcs. For instance, if I had a calc that was the following:

Calc =

Case(

Thanks Chuck, I'll try your suggestion and I'm sure it'll work, but I still would like to find out what's the maximum permisible size of a formula..

Thanks

We recently found out the answer to the maximum size of a calculation formula in FMPRO 5.0. It is 30,000 characters - and it also seems to count spaces as a character.