RowNo() alternative

[dzmitry_shmurye]

Hi community!

I am trying to create expression for generate Row numbers in the straight table but without using RowNo() function.

I have tryed to write expression like this:

RangeSum(1,Above(Rows))

But I need generate Rows values only for first fives rows in the table (P1 - P5) and for others rows it's should be Null values in the Rows expression.

Could somebody help me resolve this issue?

[Anonymous · Accepted solution]

Hi Dzmitry,

For load order you have to set a RowNo or RecNo on script, if your order will set by a value, then use this value.

For load order:

     Ascendent: IF(Rank(Total Min(-Num(PositionLoad)))<=5,Rank(Total Min(-Num(PositionLoad))))

     Descendent: IF(Rank(Total Min(Num(PositionLoad)))<=5,Rank(Total Min(Num(PositionLoad))))

For calculated value:

     Ascendet: IF(Rank(Total Sum(-Value))<=5,Rank(Total Sum(-Value)))

     Descencet: IF(Rank(Total Sum(Value))<=5,Rank(Total Sum(Value)))

Regards.

[dzmitry_shmurye]

Thanks!

IF(Rank(Total Min(-Num(FieldIndex('Product',Product))))<=5,Rank(Total Min(-Num(FieldIndex('Product',Product)))))

I use this formula and it's work fine for load order.

[Anonymous]

Your welcome!