Want whole numbers in rendering

[rhearns1]

I created a pretty neat workflow with the help of this community.  THANK YOU!

I have one problem, the input data has whole numbers; however, the report renders into a XX.XX.  I have tried changing the field type to byte, int8, int32, etc. to no avail.

How do I get whole numbers in my report?  Please help!

rene

[alexnajm]

Glad to hear about the usefulness of the Community! If you are using the Table tool, click on the number column and change the decimal places to be 0.

[rhearns1]

Okay, now I will show my naivete.  Table tool?

I start with an Excel spreadsheet import, then some conversions, filtering, etc., etc.  I have never seen the table configuration.  

[alexnajm]

My assumption was that if you are rendering as mentioned, you would likely be using a Table tool. My mistake!

You have to look in two places then (this is me guessing since I don't have visibility into your configurations)

• Are you rounding your numbers using a Round function and storing them as Integers?
• Is your data before your output data tool showing decimals, or is it just in Excel?

[rhearns1]

I changed the following fields (eGFR, NT-proBNP, LVEF, from Double to either Byte or Int32. I tried Int8 etc. and kept rerunning the workflow but kept getting numbers after a decimal point that doesn't appear in the original data.

Added a data view of what it appears.   Figures are not in order.  1) is eGFR/NT-proBNP data type, 2) the LVEF data type, 3) the data results no decimals 4) the rendering result

  

  

 

 

[apathetichell]

are you ouptutting to excel? and my next question is are you outputting to a template file that you stored as a blob (ie overwrite sheet/range)? If so the formatting exists in your template in excel and you should change it there...