Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to calculate the percentage of the cell relative to the entire column?
Something like count(Field)/count(SUM Field for entire column).
I have tried many options (especially with TOTAL and filters) but none of them gave me the right answer.
The table is looking something like this:
In the meantime, I have found the solution, in case anyone wants to use it:
Count(field)
/
(RangeSum(Below(count(field),0,(NoOfRows()-RowNo()+1)))+RangeSum (above(count(field),1,(RowNo()-1))))
Basically there is the sum of all the values above and all the values below including the current one.
In the meantime, I have found the solution, in case anyone wants to use it:
Count(field)
/
(RangeSum(Below(count(field),0,(NoOfRows()-RowNo()+1)))+RangeSum (above(count(field),1,(RowNo()-1))))
Basically there is the sum of all the values above and all the values below including the current one.