1

I'm trying to make a calculation with a selected value in a choice field in combination with 2 other Integer fields. I created the following code:

`Calculation 1 = a text type
Choicefield = a dropdown/with several predefined values
Value 1 = a Integer Type number field 

=(if Choicefield ="Choice1" and Value1 <3 then 72 * Value1 else if    
Choicefield = "Choice1" and Value1  >2 and Value1 <5 then Value1 * 67.5 else if 
Choicefield = "Choice1" and Value1 >4 and Value1 <10 then Value1 * 63 else if 

Choicefield = "Choice2" and Value1 <3 then 80 * Value1 else if 
Choicefield = "Choice2" and Value1 >2 and Value1 <5 then Value1 * 75 else if 
Choicefield = "Choice2" and Value1 >4 and Value1 <10 then Value1 * 70  
So on for the other choices.....
else "")`

I have a second calculation field:

Calculation 2 = a number type
Value2 = a Integer type Number field
=Value2 * 0.35

In my last field I want to add the values from Calculation 1 and Calculation 2 together:

Calculation 3 = a Number Type
=Decimal.Parse(Calculation 1) + Calculation 2

The issue exists when trying to multiply with the decimal value 67.5 in my first calculation. As you can see if I enter 3 in my value1 field the calculation would be 67.5 * 3 = 202,50 however, in my third calculation field "2.025,00" is shown instead of 202,50. How do I calculate with decimals in my first calculation field so the correct price is shown in my final calculation (3) field?

0

The issue resolved after I changed my first calculation field into a Number type. Earlier this resulted into an error, as you can see in my example above at the end of the code I close with a string 'else "" ' instead of a number 'else 0' which caused the error.

It is also unnecessary to parse calculation 1 into a decimal in Calculation 3.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.