Display 99.9% instead of 100% , truncated rather than rounded.

Here is what I did.

cast(cast([calc_column]*100,integer), decimal(19,2))/100

Comments

  1. Sometimes I write articles on a topic how to write Educational topics and Students frequently ask me how to write creative brief - I recommend to people to read a blog by the link above.

    ReplyDelete

Post a Comment

Popular posts from this blog

Cognos 10 Active Report - Swipe Gesture

How can you extract all user information from Cognos Access Manager Namespace Report Utility and create Cognos Report out of it?

How to extract List of Users Vs Groups from Content Store (c8 . Oracle 10g )