Non repeat a column if a group

[Former Member]

HI I would like to print the group which is the order# on each line. Mainly for excel export reasons.

but i want to surpress the order# if it's repeated.

When I make the change on format of the field Common and tick 'supress if duplicated' it's not doing it.

So does this not work if its a group?

[abhilash_kumar · Accepted solution]

Hi Paul,

Create a formula with this code and use it as the 'Order #' on group:

If OnFirstRecord then {Order#} else

if previous({Order#}) = {Order#} then ""

else

{Order#}

-Abhilash