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

    Calculation Error ; an operator is expected WHERE?

    AnthonyTesoriero

      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")