Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
=Aggr(If(Sum(Invoices) < 0, '< 0', Class(Sum(Invoices), 1000000, '$')), [Invoice Number])
Try this
=Aggr(If(Sum(Invoices) < 0, '< 0', Class(Sum(Invoices), 1000000, '$')), [Invoice Number])