The table below is what I show.
The grey values are expressions, the white ones are the dimensions.
In the field count I need a number which counts up from 1, 2, 3, 4, 5, .. .etc (just from first to last row)
I tried the function RowNo():
And the function RowNo(TOTAL)
The RowNo(TOTAL) looks somehow what I need, but I only need the rows with a value.
When saying that to the count column it shows the numbers 3, 5, 6 . . . instead of 1, 2, 3
Anyone knows how to handle this?? I just need some numbering for an export.
thx in advance,
Rank(...) is not exactly what I look for since this needs some field to rank on . . .
Did rank on value for test . . . but now I get empty rows ( null() ) which I can't really seem to get rid of ...
expression for the count column:
(Serviceorders.EventType = 1 and Serviceorders.Orderdatumtijd >= timestamp(vLastLoadDateTimeNUM))
(Serviceorders.EventType = 3 and Serviceorders.Einddatumtijd >= timestamp(vLastLoadDateTimeNUM))
If ranking a value ... the problem which occurs is that if a value is shown more than once the rank shows e.g. 5-6 (see sample below)
is there another way to show just a 'front' number which just adds one up