reporting services - Converting an Excel Formula into SQL Report Builder Expression -
i have been given excel formula , need work in ssrs report builder 3.0 expression, original excel formula:
if(a01>12,round(a01/24,0),1)
instead of cell a01 value field in ssrs called [diff]
essentially expression round number of hours number of days hours aren't inputted in 24's.
thanks
try:
=iif(fields!diff.value>12,round(fields!diff.value/24.0),1)
let me know if helps.
Comments
Post a Comment