-
-
2. Re: cumulative sum
Okechukwu Ossai
Jun 29, 2017 5:00 PM
Hi Mendey,
You can use Previous_Value to calculate the running sum and use IF statement to make the first row zero.
Step 1: Create calculated field [Cumulative Sum]
IF FIRST() == 0 THEN 0
ELSE PREVIOUS_VALUE(0) + SUM([Value])
END
Step 2: Create your view. Right click on [Cumulative Sum] and select Compute using "Table (Down)"
Hope this helps.
Ossai
-
3. Re: cumulative sum
when i do a calculation like this(1-(A/B) i need to get the value 35.42 where i am getting a value like 8.98 what i observed is when i change it to dimension it is working fine but my concern here is i need to add suffix to the number.
Can anyone please suggest me the solution.
Thanks in Advance.
