Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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