Accumulate a calculated field in the script and/or in the front view?

[#1]

Hi all,

I´ve been searching for a solution to this easy cuestion but I didn´t find it or I was not able to make them run ; )

I want to accumulate a this calculated field:

count(Artikel)/count(TOTAL(Artikel))

The table should looks like this

Artikel	count(Artikel)	count(TOTAL(Artikel))	count(Artikel)/count(TOTAL(Artikel))	Accumulated
851-320-T2	5	1000	0,50%	0,50%
352-30-30-M8-E-55	4	1000	0,40%	0,90%
617-5-A	4	1000	0,40%	1,30%
565-26-192-SW	4	1000	0,40%	1,70%
6336-KU-40-M8-K	4	1000	0,40%	2,10%
508-10-M8-10	4	1000	0,40%	2,50%
6319-21-C	3	1000	0,30%	2,80%

Which is the best method? Script or front view?

with rangesum (above(count

or Peek?

Thank you very much.

Urdru

[#2 · Accepted solution]

Try:

RangeSum(Above(Column(4)), Column(3))

Regards

Rahul

[#3]

I think you can just use Column(3)/Column(4) and do the required formatting in the Number tab of the properties.

[#4]

Does our solution makes sense?

[#5]

Thank you very much and sorry for the late response.