I want to calculate cumulative sum for column ‘Net Weight’ by Year . Below picture is result i want to have.Column definition:‘SO Created Year’ = ROUND_YEAR("VBAK"."ERDAT") ‘Created Month’ = ROUND_MONTH("VBAK"."ERDAT") ‘Net Weight’ = KPI(“so_netweight”) Cumulative Sum= if I use formula : RUNNING_SUM(kpi("so_netweight"),order by("vbak"."so_creatd_year"), partition by("vbak"."created_month_so_")) , i got below error. can anyone help ?

Solved

Cumulative Sum Question

I want to calculate cumulative sum for column ‘Net Weight’ by Year . Below picture is result i want to have.

Column definition:

if I use formula : RUNNING_SUM(kpi("so_netweight"),order by("vbak"."so_creatd_year"), partition by("vbak"."created_month_so_")) , i got below error.

can anyone help ?

Best answer by fabian.wende

thanks @fabian.wende .

But it does not group by ‘Created Month (SO)’ . It still give me the detail list. can help you ?

Yes I can help - I forgot to mention that you have to Aggregate the running_sum again:
This should be working fine:
SUM(RUNNING_SUM(*****))

+1

You can’t use RUNNING_SUM on an SUM aggregate which then should be grouped in another way. Just use your RUNNING_SUM this way:

RUNNING_SUM(

"VBAK"."NETWR",

order by("vbak"."created_month_so_"),

partition by("vbak"."so_creatd_year")

)

(Additionally you switched order by and partition by, which I fixed)

Best regards,

Fabian

thanks @fabian.wende .

But it does not group by ‘Created Month (SO)’ . It still give me the detail list. can help you ?

+1

thanks @fabian.wende .

But it does not group by ‘Created Month (SO)’ . It still give me the detail list. can help you ?

Yes I can help - I forgot to mention that you have to Aggregate the running_sum again:
This should be working fine:
SUM(RUNNING_SUM(*****))