Forum Discussion
tristaanogre
8 years agoEsteemed Contributor
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.
- doug_bowen8 years agoOccasional Contributor
If that's the case, should I be truncating the value using SQL?
If so, I can update the SQL to truncate.
- tristaanogre8 years agoEsteemed Contributor
I'd give that a try at least.
- doug_bowen8 years agoOccasional Contributor
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.