Textbox expression returning error

  • mharbuz

    Say Hey Kid

    Points: 678

    Hi,

    I have an expression in a cell of a table in SSRS. Whenever I try the preview the report it is coming up with this error: "The Value expression for the textrun ‘Standard.Paragraphs[0].TextRuns[0]’ contains an error: [BC30471] Expression is not an array or a method, and cannot have an argument list."

    My expression is this:

    =EXP(-POW(Fields!Time.Value-ReportItems!Mean.Value,2)/(2*ReportItems!Var.Value))/(SQRT(2*PI()*ReportItems!Var.Value))

    Can you see anything obvious that could be causing this?

  • rVadim

    Hall of Fame

    Points: 3897

    What is PI()  ? I don't see it in the list of math functions. I'm on 2008 thou, maybe it was added in 2016.

    --Vadim R.

  • mharbuz

    Say Hey Kid

    Points: 678

    rVadim wrote:

    What is PI()  ? I don't see it in the list of math functions. I'm on 2008 thou, maybe it was added in 2016.

    Ah, that was meant to be Pi (the mathmatic number) I know it is a function in SQL so I hoped it was also in SSRS but obviously it isn't. I have swapped it with Pi to 9 decimal places and it now works 🙂

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

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