• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1290
  • Last Modified:

Cast Integer - is auto rounding, ex. 1234.00

The below calc field is giving me .00 and I want to see the number.  Here is my expression

cast(([field1]-[field2]),INTEGER)
result is 12345.00, I would like to see the value for .00.  

How would I fix this expression?  Thanks
0
Vinez
Asked:
Vinez
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
I'm not a Cognos person but typically INTEGERS don't have decimal places.

Try: cast(([field1]-[field2]),DECIMAL)
0
 
VinezAuthor Commented:
This did not work, but thanks.  Not sure what is going on.
0
 
slightwv (䄆 Netminder) Commented:
Maybe FLOAT?

Leave it open for a while.  Maybe a Cognos Expert will have the answer.
0
 
adamyCommented:
Is this in Report Studio? if yes, there is "Data Format" Proerties, click "Data Format", Change "Format Type "to "Number", Change "No. of Decimal Places" to "0"
0
 
VinezAuthor Commented:
that doesn't work but I will accept your answer
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now