I'd like to use a calculation that says

If the value in payment type is equal to the value on the 1st record in lookup payment type, use PaymentAmount, if not use 0. I

t seems like a simple calculation and I can't find an error in my approach. But filemaker 14 continually returns the error "An operator (e.g. +, -, *, …) is expected here."

Here is the calculation that I think ought to work:

If (PaymentType = "GetNthRecord (lookupPaymentType::PaymentType"; 1); PaymentAmount; 0)

Here is the calculation highlighted after the error.

Based on the error I've changed things around; but never with success.

I tried

If (PaymentType = ("GetNthRecord (lookupPaymentType::PaymentType"; 1)); PaymentAmount; 0)

Oddly I get the error There are more “)” than there are “(” or there are more “(” than there are “)”. I think I can count and I count 3 openers and 3 closers.

Here is the calculation highlighted after that error:

Any ideas/help is much appreciated.

Remove all quotation marks that you have in this example ... it should then work assuming appropriate relationships are in place between the table called tblNVOICE and lookupPaymentType

Regards, Stephen S