Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to use the RangeSum function and above on a table containing dates.
I want the dates displayed in the table to be displayed in descending order.
Can I change the order of count? I tried to use "below",but it doesn't work.
I wanna count from the oldest date to newest date.( from bottom to top)
I don't wanna use script.
formula:
= RangeSum(above(count(if([id]='2,[id])),0,RowNo(total)))
Thank you.
Could you paste your below example? It should work.
There is a opened and never closed ' in your expression
RangeSum(above(count(if([id]='2,[id])),0,RowNo(total)))
Could you paste your below example? It should work.
There is a opened and never closed ' in your expression
RangeSum(above(count(if([id]='2,[id])),0,RowNo(total)))