hello,

I have a summary field which is:

Sum ( T12i_invoices_LINE_ITEM||flag_product_id|::Quantity)

I want the result of it to be an absolute number.

How is the way?

Thanks in advance.

That is not a summary field, it is a calc field that uses Sum ( ). Quite different.

Abs ( ) function.

However, why is your Quantity negative? Why would absolute value be of use here?

That is not a summary field, it is a calc field that uses Sum ( ). Quite different.

Abs ( ) function.

However, why is your Quantity negative? Why would absolute value be of use here?

I have a database in which i enter invoices. I purchase some products from a vendor. So i have the ability to inspect how much i own to the vendor and which products i have purchased form him.

Some invoices from the vendor are for some products that i have returned so the total price must be decreased in that case so i should find a way to overcome this problem. The solution was to have a filed which will have the value 1 for the purchases and -1 for the invoice which have returned products. In this way i solved the problem with the money i own to the vendor.

In short time i realized that i have an invoice that have some product purchased and some products that i have returned. For that problem i found that if i enter in the quantity field a minus the problem is solved but the total quantity of the invoice is reduced. In order to overcome that problem i thought the Abs () function but i couldn't make it work. Where should i place the Abs () function?

I have a database in which i enter invoices. I purchase some products from a vendor. So i have the ability to inspect how much i own to the vendor and which products i have purchased form him.

Some invoices from the vendor are for some products that i have returned so the total price must be decreased in that case so i should find a way to overcome this problem. The solution was to have a filed which will have the value 1 for the purchases and -1 for the invoice which have returned products. In this way i solved the problem with the money i own to the vendor.

In short time i realized that i have an invoice that have some product purchased and some products that i have returned. For that problem i found that if i enter in the quantity field a minus the problem is solved but the total quantity of the invoice is reduced. In order to overcome that problem i thought the Abs () function but i couldn't make it work. Where should i place the Abs () function?

OK, it worked. The problem with the Abs () function was a space line. :-)))