Hi

I am creating an invoice which include product name, qty, unit price, extented amount but I need to put a

I believe you may just need a simple multiplication for the discount.

This will gove you the discounted total

TOTAL = SubTotal * (1.00 - (AgencyDiscount))

of course discount is already assumed to be in the proper percentage format (eg 10% is entered as ".10", not "10". However, if the standard is to enter the number as a whole, not in decimal fornmat, the use (x/100) in place of the number

Hi Bruce,

Thank you for your tips. I will try your suggestions!

Sanat