AnsweredAssumed Answered

Help with a IF and Get(FIELD) calculation

Question asked by kilbot on Oct 5, 2010
Latest reply on Oct 6, 2010 by LaRetta_1

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

Outcomes