• 0

# Compute

## Question

How can I calculate the amount to be paid by customer? If user enters 1-amount is \$5, if 2- \$20, if 3- \$35.

TIA

## Recommended Posts

• 0

Hi Jess147,

You can create a Calculated Value for that.

You can try the following formula:

CASE
WHEN
[@field:Amount_Paid] = 1 THEN 5
WHEN
[@field:Amount_Paid] = 2 THEN 20
WHEN
[@field:Amount_Paid] = 3 THEN 35
END

You just need to change the field name.

-JolliBeng

##### Share on other sites

• 0

This works! Thanks a lot JolliBeng!

##### Share on other sites

• 0

you can also try putting the formulae in a formula filed so it can be also saved on your table

##### Share on other sites

• 0

In submission page you can select calculated value as form  element for the amount :

CASE

WHEN [@field:Amount] = 1 THEN 5
WHEN [@field:Amount] = 2 THEN 20
WHEN [@field:Amount] = 3 THEN 35

END

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.