Nov 19 2021 03:58 AM
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.
Code | Description | (Hidden column)Cost price | Sales price |
AB111 | Product A | € 51,41 | € 102,85 |
AB112 | Product B | € 34,91 | € 69,85 |
AB113 | Product C | € 34,16 | € 68,35 |
AB114 | Product D | € 123,86 | € 247,75 |
AB115 | Product E | € 9,11 | € 18,25 |
Nov 19 2021 04:33 AM
Like this perhaps?