Could it be a rounding error? The actual value being returned by your SQL query could be rounded off in the report while the stored value is actually truncated at the 7.
If that's the case, should I be truncating the value using SQL?
If so, I can update the SQL to truncate.
I'd give that a try at least.
I'll try that, however once this test failed it gave me the option to update the checkpoint. After updating the checkpoint it passes. But when I try to store that value in our Source Control (Git), it tells me there is no difference in the checkpoint, thus not allowing me to stre the updated checkpoint.
If that is the case, then theoretically even truncation using SQL shouldn't produce a different result.
But I'll try it.
I've seen that happen with checkpoints before. Even though it looks like both of your values are the same type, the actual value may be coming across as something different. Try forcing your actual value into the same type as your accepted value using aqConvert inside the checkpoint and see if that helps.
