Jump to content
• 0

# I want to calculate a field based on the other field's value

## Question

I am trying to calculate my field "Equivalent" depending on the value of another field "Estimate".

So, I have a field "Estimate" with  3 values: Minimum, Maximum and Average then I want to do a calculation in my field "Equivalent" depending on the "Estimate" field's value.

These are the following formula for each value.

Minimum = Equivalent * 0.10

Maximum = Equivalent * 0.25

Average = Equivalent * 0.15

Can I do this?

Cheers,

Z

## Recommended Posts

• 0

Yes it can be done.

You can create a calculated/formula field then insert the following code:

CASE
WHEN [@field:Estimate] = 'Minimum' THEN [@field:Equivalent] * 0.10
WHEN [@field:Estimate] = 'Average' THEN [@field:Equivalent] * 0.15
WHEN [@field:Estimate] = 'Maximum' THEN [@field:Equivalent] * 0.25
END

Alternatively, if you wish to add or do something to the logic above, you may visit our Function Reference article on this link: https://howto.caspio.com/function-reference/

I hope this helps.

H

## 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.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

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

Loading...
×
×
• #### Browse

×
• Create New...