Possible to cumulate values in a table?

[Former Member]

I`d like to show cumulated values in a table - i.e. a cumulated percent value. By now I have the originally value - is it possible to cumulated it with a function or is there another possibility?

Thanks in advance!

Regards..

Flo

[Former Member · Accepted solution]

U can make formula by adding all the values in the last column like this :-

Click the formula button of the expression field

and sum it like this (@NUM1@NUM2@NUM3)/3

Regards

Navneet

Please acknowledge if it helps.

[Former Member · Accepted solution]

Thanks for your answer, but it doesn`t help, because I`d like to have such a table

___________________ <b>%-value___%-value-cumulated</b>

<b>Customer A</b>_____________5______________5

<b>Customer B</b>_____________5______________10

<b>Customer C</b>_____________10_____________20

<b>Customer D</b>_____________4______________24

Best regards!

Flo

[Former Member · Accepted solution]

If there is no data entry by user you can build such a structure at backend and pull the same in VC TABLE. This is most ideal.

If there is any data entry by user , probably you may want to avoid passing the data to backend. In this case if the rows and columns are static you can build a look a like table using Expression box (compute dependent formulas as you desire)

[Former Member · Accepted solution]

Hi Flo,

your data comes from a query? If so then you can use the cumulated keyfigure.

Best Regards,

Marcel & Sven

[Former Member · Accepted solution]

I hoped that I could avoid that.. but that will be the fastest way - so I`ll do so

Thanks and Regards!

Flo