TOTAL ROWNO()

[Anonymous]

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.

[swuehl]

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))

[perumal_41]

Hi Alex,

i have attached application please chech out..This one slove your problems.

[Anonymous]

When adding the function IF it does not total more.