I have a pretty straightforward comparison of two values that is not giving the intended results.
The page calculates the total qty of a sale of a part from history and compares that number to what the system thinks the total qty sold is.
Basically, I have an On Hand quantity of a part. I calculate the entire part's sales and purchase orders to get with what the system should be at, based on history, and compare the two.
Recently, we decided to change the qty field from INT to FLOAT (sql 2014 back end) to accommodate for some manufacturing measurements.
So, as of now, I have a page that has this comparison:
if cDbl(rs("CalculatedShelfOH")) <> cDbl(rs("CardOH")) then
The CalculatdShelfOH is 2.126 and the CardOH is 2.126. But, the code is "doing the stuff" even though they match.
What am I missing / doing wrong?