Is it possible to convert a freetext to a currency value via formula? Trying to compute a Purchase Order's total discount via workflow. Was thinking of multiplying the Term discount % (it's a freetext field though) to the PO's subtotal field(also a freetext) but it should result to a Currency or number type of field.

Wrap the fields with TO_NUMBER to convert the text to numbers that you then then do your math.

if both fields are free text would I have to enclose both in separate TO_NUMBERS? ex. if I'm multiplying {customfield1} and {customfield2} both are freetext how would the formula look like?

TO_NUMBERS(customfield1) * TO_NUMBERS(etc

Doesn't seem to work for me..how would you make the formula for the Total Discount for the Purchase Order? assuming you'll be taking the discountpercent field in the Term you put in the PO and multiplying that with the PO's subtotal field(located in the summary box)?