Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone,
suppose i have
A
1
2
3
-
4
column in backend
now i want to give row no to
A rowNO
1 1
2 2
3 3
- 3
4 4
in UI
i want to do this in UI only since data in backend is huge,
is there a way i can do this
thanks ,
vikas
Hi,
try this:
if(len(trim(A))<>0, rowno()) as Rowno
in your table object you can add a new measure as below:
if( not isnull(A) or len(trim(A)) > 0, rowno(TOTAL) )
it does not give the right ans
anyway thanks for the help
hi not is null does not work with if in chart
Hi Vikas,
Is it a '-' or null value in your data ?
Br,
KC
its a null value