While messing around in SSRS, I came across the FIX function, which made me giggle a little as I was imagining a Fixer within Reporting Services sorting out all those little gremlins you get when running a report, I blame the child in me, but I digress.
So you maybe asking, like I did, what is the FIX function and what does it do?
In SSRS the FIX function returns the integer of a Numeric data field.
=FIX(Fields!Last_Year_s_Sales.Value)
It will just return all the numbers to the left of the decimal point, ignoring rounding or any data transformations.
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us | 
