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:
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
Public Shared Function GetTotal()
Replace the original expression
Add a new column after the SalesAmount column, then use the following expression to get the accumulated value:
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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.