Hi Erik,
Do you have a recommendation on an expression that could used on a Report Calculated field to modify the standard BC system Line No sequences.
For example, the standard system format seems to follow “10000, 20000, 30000” and so on, however we’d prefer to have these shown as ‘1’, ‘2’, ‘3’, in single digits instead.
Do you have a recommendation for an expression that could work?
Best Regards,
Jack
The way it works behind the scenes, is that when you insert a line between line 10000 and 20000, the new line becomes 15000, insert a new line again, it becomes 12500 … and so on and so on. You can actually run out of line really quick.
So just dividing with 10000 won’t work. It might work, but you’ll get line numbers 1.5 and 1.25 and 1.12 and 1.06 …. And that doesn’t really work.