How to have Line number only on desired rows
Posted: Thu May 05, 2016 6:28 am
Hello
I have a problem to do this. in some rows I have set a condition. if the condition is true I want to show the Line number and if the condition is not true I'd like to show the empty string and the line number should not raise when this happens. look at the picture
in this case I want the row number be like:
53
54
55
""
56
57
.
.
.
here's the cell value:
{IIF(Passenger.No != 3, Line, "")}
I have a problem to do this. in some rows I have set a condition. if the condition is true I want to show the Line number and if the condition is not true I'd like to show the empty string and the line number should not raise when this happens. look at the picture
in this case I want the row number be like:
53
54
55
""
56
57
.
.
.
here's the cell value:
{IIF(Passenger.No != 3, Line, "")}