SSRS Expression Error

  • I am getting the following error when I try to use the Expression below. Any insight on where I messed up is deeply appreciated.

    The 'Value' expression for the textrun 'Textbox3.Paragraphs[0].TextRuns[0]' contains an error: [BC30198] ')' expected.

    ----------------------------

    The definition of the report '' is invalid.

    ----------------------------

    An error occurred during local report processing.

    =CODE.Divide(Sum(CDbl(Fields!Numerator.Value,0), "dsMain") ,Sum(CDbl(Fields!Denominator.Value,0), "dsMain"))

    Public Shared Function Divide(Num1 as double, Num2 as double) AS object

    IF IsNothing ( Num1 ) or IsNothing (Num2) or Num2 = 0 Then
    Divide = 0
    Else
    Divide = Num1 / Num2
    End If

    End Function
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • I'd say it's because the CDbl function only expects one parameter value and you supply two.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply