Filter Computation Issues

I have 3 fields "Active Asset Cost", "Additions Cost", and "Cost Adj". I want to filter out any entries where the Active Asset Cost isn't the Additions Cost + Cost Adj. I created a filter with just that equation [Active Asset Cost] = [Additions Cost]+[Cost Adj] . It correctly filters 24 of my 33 test items, but of the 9 it filtered out only 1 actually doesn't make the statement true. I first thought it was a rounding issue, but I've checked and all of the fields are fixed decimal 19.2. Any thoughts on what I'm doing wrong or how to troubleshoot?

FA process.JPG

Tips and Tricks

Help

Accepted answers

atcodedog05

Agree with @Jean-Balteryx has an additional debugging step you can create a new column for calculation and also for one where you are taking the difference to check whether [Active Asset Cost] - ([Additions Cost]+[Cost Adj]) = 0 no difference even to a decimal.

Hope this helps : )

All comments

atcodedog05

Hi @KyleF

There is 2 things you can do.

1. Change the datatype to double.

2. Round the number to 19.2 using round() function and then compare.

Hope this helps : )

Jean-Balteryx

Hi @KyleF ,

Have you tried creating a field making the sum of addition cost and adj cost to check if the result is really the same ?

atcodedog05

Hope this helps : )

Jean-Balteryx

Nice check step @atcodedog05 !

KyleF

Thanks. Everyone. I was thinking about those solutions, but was just making sure I wasn't missing something or doing something wrong before I created the additional steps. I wonder if my own solutions are always more complex and less efficient than they should be.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703