2 Replies Latest reply on Oct 6, 2010 4:37 AM by LaRetta_1

    Help with a IF and Get(FIELD) calculation

    kilbot

      Title

      Help with a IF and Get(FIELD) calculation

      Post

      Okay this is what I have wrote and I know I'm wrong somewhere just can't figure it out.

      If (DBE::udbe_marker = "dbe" ; GetField ( "bid_quote" ) ; "1" )

      DBE:udbe_marker is a field that I setup that based off of certain criteria marks a company as a DBE or UDBE. I am trying to write a calculation that if the DBE:udbe_marker field =DBE, then to grab the amount from the bid_quote field. The bid_quote field is a number field. I have set the calculation to come out as a number. What am I doing wrong?

      Thanks