Simple Subtraction

I'm just trying to subtract one column from another in formula (these are small integers). If I use the following, I get "Formula: Invalid type in subtraction operator". I'm setting the new column Data Type to "Int32".

[Openings] - [Openings Filled] and my new column name is "# Openings Remaining".

Workflow

Accepted answers

MarqueeCrew

if you put a select in front of your formula tool, are these two fields truly NUMERIC?

All comments

MarqueeCrew

if you put a select in front of your formula tool, are these two fields truly NUMERIC?

mattcoleman

That was the issue, they were coming in as V_WString. When I used SELECT to change them to Int32, the subtraction worked. Thanks!

Kim2

Hi, I am having a similar issue, however I changed everything to Int32 and am still not getting the right subtraction. Its messing up where I have a 0-35 so I would want my variance column to be -35 but it is coming back as 0. Do you know why that may be?