Table Discount vs GrossProfit

%3CLINGO-SUB%20id%3D%22lingo-sub-2984979%22%20slang%3D%22en-US%22%3ETable%20Discount%20vs%20GrossProfit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2984979%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EThe%20situation%20is%20that%20a%20salesguy%20has%20an%20overview%20of%20the%20product(numbers)%20and%20the%20gross%20sales%20price.%3CBR%20%2F%3EIf%20he%20needs%20to%20create%20a%20quotation%2C%20he%20should%20be%20able%20to%20see%20what%20the%20gross%20profit%20will%20be%20if%20het%20offers%20x%25%20discount.%3C%2FP%3E%3CP%3EThis%20I%20would%20like%20to%20have%20in%20a%20table%2C%20where%20the%20salesman%20only%20has%20to%20fill%20in%20the%20%25%20discount%2C%20and%20automatically%20the%20gross%20profit%20%25%20will%20pop%20up.%3C%2FP%3E%3CTABLE%20width%3D%22500%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2275%22%3ECode%3C%2FTD%3E%3CTD%20width%3D%2294%22%3EDescription%3C%2FTD%3E%3CTD%20width%3D%2279%22%3E(Hidden%20column)Cost%20price%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ESales%20price%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAB111%3C%2FTD%3E%3CTD%3EProduct%20A%3C%2FTD%3E%3CTD%3E%E2%82%AC%2051%2C41%3C%2FTD%3E%3CTD%3E%E2%82%AC%20102%2C85%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAB112%3C%2FTD%3E%3CTD%3EProduct%20B%3C%2FTD%3E%3CTD%3E%E2%82%AC%2034%2C91%3C%2FTD%3E%3CTD%3E%E2%82%AC%2069%2C85%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAB113%3C%2FTD%3E%3CTD%3EProduct%20C%3C%2FTD%3E%3CTD%3E%E2%82%AC%2034%2C16%3C%2FTD%3E%3CTD%3E%E2%82%AC%2068%2C35%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAB114%3C%2FTD%3E%3CTD%3EProduct%20D%3C%2FTD%3E%3CTD%3E%E2%82%AC%20123%2C86%3C%2FTD%3E%3CTD%3E%E2%82%AC%20247%2C75%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAB115%3C%2FTD%3E%3CTD%3EProduct%20E%3C%2FTD%3E%3CTD%3E%E2%82%AC%209%2C11%3C%2FTD%3E%3CTD%3E%E2%82%AC%2018%2C25%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2984979%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2985087%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20Discount%20vs%20GrossProfit%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2985087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1223896%22%20target%3D%22_blank%22%3E%40GW-2404%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELike%20this%20perhaps%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?