Reporting - IIF inside Sum gives unexpected #error in expression

Yes ! Was really confused with this error when saw it, missing details of the errors made me crazy
after 1 hour I got an idea.
so how it looked for the first time

=Sum(IIf(Fields!ContractID.Value <> 0, Fields!hours.Value,0))

I was 100% sure that it should work , but it did not !!!!
the reason is in Fields!hours.Value, it returns STRING which cannot participate in Sum expression
yes, now it's clear. So expression should look like

=Sum(IIf(Fields!ContractID.Value <> 0,CDbl(Fields!hours.Value),0.0))

hope this will save your time !!!


Popular posts from this blog

Testing Azure Functions locally with automated integration test

Running Stockfish hosted in Azure function

Consuming Web API using JavaScript and XMLHttpRequest method