Hello,
I'm new to FME and trying to find my way around and could use a little help. I'm trying to subtract one attribute from another and test that it is above one value and below another. My thought was to use the arithmetic editor in the Tester translator, however, the items that pass are not correct. Below is a screenshot of what I'm trying to do but the results appear to be the opposite and have a result value greater than 1000. What am I doing wrong?
Thanks!
Are you sure that every feature has a value for both "2016 Assessed Value" and "2015 Assessed Value"?
I just tried the following and it worked as expected:
Thanks for the reply David, no not all features have a value but I thought the @sub function was able to handle empty features? And for the few that "passed" the test why is the result greater than 1000? Thanks again!
,Thanks for the reply David, no not all features have a value but I thought I read that the @sub function was suppose to handle empty features? And for the few that did pass the test, why is the result greater than 1000? Thanks again!
Thanks for the reply David, no not all features have a value but I thought the @sub function was able to handle empty features? And for the few that "passed" the test why is the result greater than 1000? Thanks again!
,Thanks for the reply David, no not all features have a value but I thought I read that the @sub function was suppose to handle empty features? And for the few that did pass the test, why is the result greater than 1000? Thanks again!
+19Thanks for the reply David, no not all features have a value but I thought the @sub function was able to handle empty features? And for the few that "passed" the test why is the result greater than 1000? Thanks again!
,Thanks for the reply David, no not all features have a value but I thought I read that the @sub function was suppose to handle empty features? And for the few that did pass the test, why is the result greater than 1000? Thanks again!
Here is a workspace and some data. I'm trying to narrow down the list to the features that have a result of 2016 assessment subtract 2015 assessment greater than 1 and less than 1000. I did the calculation in excel and have a column showing that I should only have 3 features pass the test. Instead I have 18 and none of which are the 3 I would expect. Let me know your thoughts.
Thanks!
+19Try removing commas from the original values before performing math operations.
+19Here is a workspace and some data. I'm trying to narrow down the list to the features that have a result of 2016 assessment subtract 2015 assessment greater than 1 and less than 1000. I did the calculation in excel and have a column showing that I should only have 3 features pass the test. Instead I have 18 and none of which are the 3 I would expect. Let me know your thoughts.
Thanks!
Try removing commas from the original values before performing math operations.
Try removing commas from the original values before performing math operations.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
