• 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. ×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.