Table Discount vs GrossProfit

Copper Contributor

Hi all,

The situation is that a salesguy has an overview of the product(numbers) and the gross sales price.
If he needs to create a quotation, he should be able to see what the gross profit will be if het offers x% discount.

This I would like to have in a table, where the salesman only has to fill in the % discount, and automatically the gross profit % will pop up.

CodeDescription(Hidden column)Cost priceSales price
AB111Product A€ 51,41€ 102,85
AB112Product B€ 34,91€ 69,85
AB113Product C€ 34,16€ 68,35
AB114Product D€ 123,86€ 247,75
AB115Product E€ 9,11€ 18,25
1 Reply

@GW-2404 

Like this perhaps?