report not accepting whole number

[mbs2016]

I'm using the following function to give me the number of days between two dates:

Days to Process = 1. * ([RDOC_ORIG_POST_DATE]-[RDOC_SCAN_DATE])

In addition, via Modeling tab, I changed the 'Data Type' for the Days to Process field to "Whole Number".  However, the value is still showing as a a decimal in the report.  Not sure what I'm missing.

[v-sihou-msft]

@mbs2016

You should also change the format of this data field into "Whole Number" and make sure the decimal place is 0. Then it will be rendered properly in visuals.

Regards,

[ankitpatira · Accepted solution]

@mbs2016 You can simply go to query editor, then under Add Column tab select Add Custom Column as below. Finally change type of resulted column to Whole Number. Also ensure both date columns are of type Date.