I notice the more fields I add together , then divide the result, the fewer decimal positions I get in my result.
For instance, the first result has 12 decimals
What's going on ? I want 2 positions of decimals for the last select where I add 12 fields together. It's dropping them and just showing 17.00
If I try to CAST as 2 decimals, they still get dropped.
I want 38.46, not 38.00
For instance, the first result has 12 decimals
What's going on ? I want 2 positions of decimals for the last select where I add 12 fields together. It's dropping them and just showing 17.00
Code:
SELECT ((SFDL01 + SFDL02) / SADLCY ) * 100 [COLOR=#FF0000]Result = 4.678465299100[/COLOR] , ((SFDL01 + SFDL02+ SFDL03) / SADLCY ) * 100 , ((SFDL01 + SFDL02+ SFDL03+ SFDL04 ) / SADLCY ) * 100 , ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05 ) / SADLCY ) * 100 , ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06 ) / SADLCY ) * 100 , ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06+ SFDL07 ) / SADLCY ) * 100 [COLOR=#FF0000]Result = 10.2363300[/COLOR] , ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06+ SFDL07+ SFDL08 ) / SADLCY ) * 100 , ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06+ SFDL07+ SFDL08 + SFDL09 ) / SADLCY ) * 100 , ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06+ SFDL07+ SFDL08 + SFDL09+ SFDL10 ) / SADLCY ) * 100 , ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06+ SFDL07+ SFDL08 + SFDL09+ SFDL10+ SFDL11) / SADLCY ) * 100 , ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06+ SFDL07+ SFDL08 + SFDL09+ SFDL10+ SFDL11+ SFDL12 ) / SADLCY ) * 100 [COLOR=#FF0000] Result = 17.00 [/COLOR] FROM TABLE_A
I want 38.46, not 38.00
Code:
CAST( ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06+ SFDL07+ SFDL08 + SFDL09+ SFDL10 ) / SADLCY ) * 100 as dec(10, 2)) [COLOR=#FF0000]Result = 38.46[/COLOR] ,CAST( ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06+ SFDL07+ SFDL08 + SFDL09+ SFDL10+ SFDL11) / SADLCY ) * 100 as dec(10, 2)) [COLOR=#FF0000]Result = 38.40[/COLOR] ,CAST( ((SFDL01 + SFDL02+ SFDL03+ SFDL04+ SFDL05+ SFDL06+ SFDL07+ SFDL08 + SFDL09+ SFDL10+ SFDL11+ SFDL12 ) / SADLCY ) * 100 as dec(10, 2)) [COLOR=#FF0000]Result = 38.00[/COLOR] FROM TABLE_A
Comment