is there any expression in ssrs.im using ssrs 2008 i want to convert my decimal to integer, nearest value(eg 34.5 =35)if not expression i have my code below.i have been able to convert into decimal so i convert back to integer now.i declare my variables to integer before so i now i change to double for me to find the average,which display my right result.so i want(average) to convert back to integer.here is partial of my code
Code:
Public Function avrage(length As string) As Double
dim Test1 As double
if length >365.25 then
Test1 =length/ 365.25
length =length Mod 365.25
length =year *365.25
Test1 =cstr(Math.Floor (length/ 365.25))
Test1=CInt(fix(length))
Test1= length
end if
end function
thanks in advance