none
RunningValue Manual

    Question

  • Good night;

    As the calculated value would get accumulated in the previous row without using the function RunningValue

    Friday, November 08, 2013 1:18 AM

Answers

  • Hello,
     
    If I understand correctly, you want to calculate the accumulated value based on the previous row without using RunningValue function. After testing it in my own environment, I find that we can use custom code to get the accumulated value. For more detail, you can refer to the following steps:

    1. In the design mode, click the menu”Report”>>”Report Properties”>>”Code” tab. Then place the code below in the section:
      Public Shared Value as double=0
        Public Shared Function GetValue(Item as double) as double
           value= value + Item
           return Item
        End Function
        Public Shared Function GetTotal()
           return value
        End Function
    2. Replace the original expression
            = Fields!SalesAmount.Value
      with
              =Code.GetValue(Fields!SalesAmount.Value)
    3. Add a new column after the SalesAmount column, then use the following expression to get the accumulated value:
      =Code.GetTotal()

    Furthermore, I still suggest that you should use RunningValue function to get the value, and I’m curious about why you don’t want to use this function.

    If there are any misunderstanding, please elaborate the issue for further investigation.

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Monday, November 11, 2013 10:01 AM