Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Multiply Formula Error

796 0
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