Help

Multiply Formula Error

Topic Labels: Formulas
1394 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tyrone_Elliott
5 - Automation Enthusiast
5 - Automation Enthusiast

Form some reason if I try to multiply or divide I get error however addition and subtraction works fine. What am i doing wrong?

Screen Shot 2020-02-27 at 8.04.31 am

1 Reply 1
Gavin_Fudge1
5 - Automation Enthusiast
5 - Automation Enthusiast

Try wrapping them in a VALUE() function:

VALUE({Hold}) * VALUE({Dosage})

INT() will do the same thing, but returns an integer rather than a float.

Bit more info on this thread