Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need help for rank accumulation .
I have used formula
rangesum(rank(total column(1)))
result is not showing properly after rank 55 .PFA excel for detailed information
That expression will sum the ranks, which is probably not what you want. Explain what you are trying to do clearly, what does your input look like and what result you are hoping for.
rangesum(above(sum(Value), 0 , RowNo()))
see the below.. You can probably do it in script
Thnx Kush ,but i want it in front end expression
try this expression
=rank(sum(index))
Hi,
Try this..
rangesum(rank(total Column(1),1))
Thnx ..this expression worked