Toad World® Forums

TDP 5.0 Pivot Grid Variance Column

I'm running TDP workbook 5.0.5.61, when I add a variance column in the pivot below, the variances shown are correct except for a few rows where large amounts are shown when the value should be zero:

Hi Steve,
what database is it? Can you check what is in the other fields' values, are there any specifics for the incorrect rows? Are the correct values truly "Os" or are they shortened?

dan

Hi Dan, database is SQL Server 2016. Not sure what's going on with the incorrect rows. Since the sum column is correct for those rows, not sure why the variance column wouldn't be correct as well. All the correct rows that show zero are truly zero.

Hi Dan, any updates on this issue?