Too few separators

[asgweb]

Hello and thanks in advance for your help.

I have 2 tables. 1st is an inventory list. 2nd is a sales table. We sell products the are reduced in price every 15 days until sold. When sold I need to enter the current price into the second table. I have this calculation for 'SellingPrice=' but I get an error that say's 'too few separators'. Any ideas?

if (SellingDate < DateIn )

if (SellingDate > ThirtyDayPrice )

if (SellingDate > FortyFiveDayPrice )

if (SellingDate > SixtyDayPrice )

[Fitch]

It should look more like this:

Case(

SellingDate > SixtyDayPrice ; 1 ;

SellingDate > FortyFiveDayPrice ; 2 ;

SellingDate > ThirtyDayPrice ; 3 ;

SellingDate < DateIn ; 4 )

But is "SixtyDayPrice" a date field?

[IdealData]

The Case statement is more elegant, however in answer to your question the separators are the ";" or "," characters depending on the localisation of the installation.

The fact is the you have NO separators at all. There should be a separator after every instance of a condition in the calculation, except after the last one. (see the case statement for example)

Incidentally how are you making FMP 4 run under Leopard? FMP 4 was for PC and Mac OS 9 only!

[comment]

Actually, you should use a lookup instead of a calculation. Or do the reduction calc in the Sales table, after looking up the DateIn from Inventory.