Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
reporting_neu
Creator III
Creator III

How to: Cells accumulate with each other

Hi,
I have to gradually add up these values, i.e. accumulate them.

reporting_neu_0-1656483345690.png

Example:

Portion Accumulate
3,60 % 3,60 %
2,92 % 6,52 %
2,56 % 9,08 %
2,22 % 11,30 %

 

SUM({$<$(GUI_CAL_PA_SET(Year,0)),V_BelegPos.offen = {'0'}, V_BelegPos.BelegArt = {'R','G'}> } V_BelegPos.pA_Gesamtpreis_HW * V_BelegPos.GS_Faktor * V_BelegPos.ZS_Faktor)
/
SUM(TOTAL{$<$(GUI_CAL_PA_SET(Year,0)),V_BelegPos.offen = {'0'}, V_BelegPos.BelegArt = {'R','G'}> } V_BelegPos.pA_Gesamtpreis_HW * V_BelegPos.GS_Faktor * V_BelegPos.ZS_Faktor)

This is the formula used to calculate the proportion. And with this formula I would have to accumulate.

Can you help me please?

Labels (1)
0 Replies