Want whole numbers in rendering

Question

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

apathetichell · Answer

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...

rhearns1 · Answer

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

alexnajm · Answer

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?