Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to bring the rowno function total ()?
DATA | RowNo | RowNo - Correct |
0 | 15 | |
31/12/2012 | 1 | 1 |
30/12/2012 | 2 | 2 |
23/01/2012 | 3 | 3 |
22/01/2012 | 4 | 4 |
21/01/2012 | 5 | 5 |
The total should be done within the expression.
The correct rowno is 15?
Not sure why you want this, are you looking for the sum of rowno?
=if(dimensionality(),rowno(TOTAL),sum(aggr(rowno(),DATA)))
or may total rowno = 5:
=if(dimensionality(),rowno(TOTAL),count(distinct DATA))
Hi Alex,
i have attached application please chech out..This one slove your problems.
When adding the function IF it does not total more.