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

Popular posts from this blog

java - Jasper subreport showing only one entry from the JSON data source when embedded in the Title band -

serialization - Convert Any type in scala to Array[Byte] and back -

SonarQube Plugin for Jenkins does not find SonarQube Scanner executable -