Class function negative values under one bucket

[Anonymous]

Hi Guru's,

i want to create invoice Buckets based on the Invoice amount.

i want to group Minus Buckets into one bucket.

how to achieve this.

Please find the attached Qvw and screen shot

Thanks,

raj

[sunny_talwar · Accepted solution]

Try this

=Aggr(If(Sum(Invoices) < 0, '< 0', Class(Sum(Invoices), 1000000, '$')), [Invoice Number])