Search code examples
reporting-servicesformulassrs-expression

How do I write CV formula in ssrs

 =StDev(fields!Maylist)/Avg(fields!Maylist) * 100

I am trying to write CV formula for my report. How can i let that formula work? I am getting error sign when i run the report. Also I would like to add that formula front of formula above IIF(IsNothing(Avg(Value)), "", . How can I correctly write expression for that?

Solution 
  •    = Iif(ISNothing(Avg(fields!Maylist.value)),0
    , StDev(fields!Maylist.value)/
    Avg(fields!Maylist.value)) *100

    It worked with that formula