Display 99.9% instead of 100% , truncated rather than rounded. Get link Facebook Twitter Pinterest Email Other Apps September 21, 2015 Here is what I did. cast(cast([calc_column]*100,integer), decimal(19,2))/100 Read more