calculate using amount field and custom dropdown

I have a drop down

pf_Publication

VALUES
The Good Councillors Guide £1.50
Being a Good Employer £0.00
It Take's All Sorts £0.00
All About Local Councils £0.00
Local Councils EXPLAINED £55.99

FEE FIELD is set to yes

FEE VALUES
1.50
0.00
0.00
0.00
55.99

I want to multiply this by the AMOUNT the user puts in and have used the formula [FORM_AMOUNT]*[FEE_VALUE]
But it keeps just returning the AMOUNT value as the £ value

I have looked through the forum and tutorial and cannot fathom the answer (I bet it is really simple)
Can you help?

Thanks

Hi Alison

This is not the correct forum for posting question related to Payment Form, so in the future, please post the question in Payment Form forum.

Regarding the question, I think you can use the solution below :

1. Since the core [AMOUNT] field coul not be used in fee formula, you should unpublish this amount.

2. Create a new textbox custom fee field, named it pf_amount

3. In the fee formula, please enter [FIELD_VALUE]*[PF_PUBLICATION]

4. Edit the field pf_Publication, set it to No

After that, check it again and it should work as expected !

Tuan

Massive apologies for putting it in the wrong forum, I really thought i had selected Payment Form forum, rushing again, too much haste making mistakes, sorry.

That works brilliantly, thank you

Great. Thanks for confirming Alison !

Tuan