Hello, I am working on an app for my mattress stores that allows the Sales Consultants to quickly calculate Gross Profit in either $$ or %.
So far I have been able to calculate the GP$ which is a simple equation of โSale Priceโ less โCost of Goodsโ.
But the cost of the sale can also affect the GP$ significantly because customers can pay for the goods in a variety of ways, here are a few different examples.
At the moment the app draws data from the โProduct Listโ table which holds, description, cost and sale prices of goods. โCost Of Saleโ Table holds data listing each method of payment (there are 25 possible variations) and the associated costs of payment by that method.
What is the best way to calculate this allowing for the many variations of deposit amount finance period and payment method?
Any assistance would be greatly appreciated.
(
Any(Select(Cost Of Sale[Percentage],[Payment Method]=[_ThisRow].[Payment Method]))
*
SUM(Select(Product List[Sale Price]))
)
Thatโs the simple version that would work for Visa & Amex
Hi Simon, thanks for that, so where do I put this code, do I put it in the Payment method column or GP$ column? Does it go in the formula field?
This formula gives you the cost of using Visa & Amex. So either put it in its own column. Or if you want to change the formula to give you Gross Profit then:
Any(Select(Cost Of Sale[Percentage],[Payment Method]=[_ThisRow].[Payment Method]))
*
SUM(Select(Product List[Sale Price]))
)
Iโve mentioned in another message to contact me directly if you need help getting this started - Simon@1minManager.com
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |