Expand my Community achievements bar.

SOLVED

Calculate NumericField

Avatar

Level 3

I have NumericField and i want to be calculated

( IF TextField1 is "Freihandlabor" then is "0", if is "CHO" then NumericField3 = NumericField1 * 3 + 300)

But TextField1 is taking words from other dropdownlist.

I'v tried with this formula but TextField1 is converting too.

Thank you

if (TextField1 == "Freihandlabor") then

  NumericField3 = "0"

elseif

          (TextField1 == "CHO") then

   NumericField3 = NumericField1 * 3 + 300

endif

1 Accepted Solution

Avatar

Correct answer by
Level 7

There is nothing in there that would change Textfield1 unless it in turn is linked to one of these fields. You should put your formula in the calculate event of NumericField3 and then the formula can just be (in formcalc):

if (TextField1 == "Freihandlabor") then

  $ = 0

elseif

          (TextField1 == "CHO") then

   $ = NumericField1 * 3 + 300

endif

View solution in original post

1 Reply

Avatar

Correct answer by
Level 7

There is nothing in there that would change Textfield1 unless it in turn is linked to one of these fields. You should put your formula in the calculate event of NumericField3 and then the formula can just be (in formcalc):

if (TextField1 == "Freihandlabor") then

  $ = 0

elseif

          (TextField1 == "CHO") then

   $ = NumericField1 * 3 + 300

endif