0

I have the below piece of coding :-

=IIf(IsNothing(((Sum(Fields!TotalCost.Value, "Accrued") + Sum(Fields!TotalCost.Value, "serv1")) / (Sum(Fields!Quantity.Value, "serv1") + Sum(Fields!Quantity.Value, "Accrued"))), (45), 
((Sum(Fields!TotalCost.Value, "Accrued") + Sum(Fields!TotalCost.Value, "serv1")) / (Sum(Fields!Quantity.Value, "serv1") + Sum(Fields!Quantity.Value, "Accrued")))

which when run in Visual Studio 2008 returns the below error:-

BC30057] Too many arguments to 'Public Function IsNothing(Expression As Object) As Boolean'.

Can anyone advise on what the error may be?

user1086159
  • 1,045
  • 5
  • 16
  • 24

1 Answers1

1

IsNothng takes only one argument. You have 3.

IsNothing Function

But i think you should move one parenthesis:

from 

=IIf(IsNothing(

to

=IIf((IsNothing
Giannis Paraskevopoulos
  • 18,261
  • 1
  • 49
  • 69