Supressing Duplicates

[goodkarma]

I have a report in Crystal 6 that I'm trying to suppress duplicates on. I'm having a problem with part of it though. I'm trying to suppress duplicates in a quantity field. The problem is there is one qty that is double all the other quantities and I don't want to suppress that quantity also. I have written a formula in the suppress if Duplicates formula spot. This is the formula I have
{record.fieldname} = previous ({record.fieldname})
or {record.fieldname} = previous ({record.fieldname})*2 this second part of the formula I thought would take the quantity of 40 and multiply it by 2 getting 80(which is the one I don't want to show) But it isn't working like I had hoped. It suppresses all the quantity until it gets to 80 then shows that and then the next 40 and then it suppresses the rest. Any suggestions would be GREATLY APPRECIATED!!!
Thanks,

 

[synapsevampire]

If 80 is the one you don't want to show, shouldn't it be:

{record.fieldname}*2 = previous ({record.fieldname})

But this is all strange, something you're terming a duplicate yet it has a different value...

I suspect that the real way to get what you want is to group on some field, and that the last number in your groups is the one you'd want to suppress, so you could use next({table.groupfield}) <> {table.groupfield}

-k