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

[Perzival]

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

[Harbinger]

Hi @Perzival

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