2 Replies Latest reply on Apr 3, 2014 11:01 AM by AnthonyTesoriero

# Calculation Error ; an operator is expected WHERE?

### Title

Calculation Error ; an operator is expected WHERE?

### Post

I can't figure out whats wrong with my case statement and what operator is expected where?

Case ((Get ( CurrentDate )-(Auction_d)) ≤  0 or IsEmpty ( Auction_d ) ; "DUE-Pending" ;
( Get ( CurrentDate )-(Auction_d))  ≥  0 and Fees_Balance_z > 0 ; "OVERDUE-" & (Get ( CurrentDate )-(Auction_d ) & "-Days")) ;
( Get ( CurrentDate )-(Auction_d))  ≥  0 and Fees_Balance_z  = 0 ; "PAID-Closed" & Fees_PAID_When_d)) ;
"-Unresolved")

• ###### 1. Re: Calculation Error ; an operator is expected WHERE?

A key clue is to note what part of your expression is highlighted when you get that error. The common causes are usually due to an extra or missing parenthesis or semi-colon.

The green parenthesis is missing from your expression and the red ones are extra. Add the green, delete the red.

Case ( ((Get ( CurrentDate )-(Auction_d)) ≤  0 or IsEmpty ( Auction_d ) ; "DUE-Pending" ;
( Get ( CurrentDate )-(Auction_d))  ≥  0 and Fees_Balance_z > 0 ; "OVERDUE-" & (Get ( CurrentDate )-(Auction_d ) & "-Days"))
( Get ( CurrentDate )-(Auction_d))  ≥  0 and Fees_Balance_z  = 0 ; "PAID-Closed" & Fees_PAID_When_d))
"-Unresolved")
• ###### 2. Re: Calculation Error ; an operator is expected WHERE?

Perfect. Thank you