CODEWITHSUNDEEP
if-statementreporting-servicesssrs-2008ssrs-expression
DNac
DNac

Reputation: 2783

IF IS nothing then count

I want to create statement such as 

=IIf(IsNothing(Fields!Amount.Value)),0,(Sum(Fields!Amount.Value)/1)

but from some reason it does not work. It should check value if it is null. If it's null, just enter 0, if it is not null, just make the calculation.

What am I doing wrong here? I am getting error for the first part of "IsNothing" code which says "Wrong number of arguments" but I do not see the error.

Upvotes: 0

Views: 410

Answers (1)

DNac
DNac

Reputation: 2783

Found it.

=IIf((IsNothing(Fields!Amount.Value)),0,(Sum(Fields!Amount.Value)/1))

Just missed brackets.

Upvotes: 2

Related Questions