Help with a IF and Get(FIELD) calculation
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?