Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
RangeSum(Above(Column(4)), Column(3))
Regards
Rahul
I think you can just use Column(3)/Column(4) and do the required formatting in the Number tab of the properties.
Does our solution makes sense?
Thank you very much and sorry for the late response.