Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

error in formula?

Status
Not open for further replies.

grecon

Technical User
Joined
Mar 8, 2007
Messages
78
Location
US
What am I doing wrong in this formula:

IF {PAYLIST.AMOUNT}+ sum{CUST.CREDIT}<>{PAYLEDGER.AMOUNT}+sum{CUST.CREDIT} then {PAYLEDGER.AMOUNT}+sum{CUST.CREDIT} else {PAYLIST.AMOUNT}+sum{CUST.CREDIT}

I get an error that "THEN" is missing
 
I have just tried to re-create your problem with no joy.
However looking at your formula, maybe it needs some brackets?

IF ({PAYLIST.AMOUNT}+ sum{CUST.CREDIT}) <> ({PAYLEDGER.AMOUNT}+sum{CUST.CREDIT}) then ({PAYLEDGER.AMOUNT}+sum{CUST.CREDIT}) else
({PAYLIST.AMOUNT}+sum{CUST.CREDIT})

dont know if that will solve your issue but its the first thing that comes to my mind.
 
Thanks it is the brackets.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top