I thought that his was fixed in an earlier version of TDP, but this gremlin has struck me again. I have created a calculated column that is a very simple formula for Gross Margin Dollars ( table1.Revenue - table1.COGS ). I ran this query several times throughout the day, and now it has decided that the result will be string value instead of a numerical value. This means that when I send the results to a Pivot Grid, the column will NOT behave as expected with an aggregation…no summing, averaging, etc…just a zero. How can this be fixed?
Here is a screen shot showing how the values are left aligned (as one would expect for text/strings), instead of right-aligned.
Toad Data Point 126.96.36.1998 (32 bit)