+6Hey guys, I'm currently stuck on how to formulate a profit based off the total value of the invoice. This is what I currently have:
I have the formulas needed to determine the selling price of each product, however via my "Invoice" tab, I have this:
Where I'm stuck at is, how to formulate the formula to determine the gross profit of each invoice in their respective columns.
Any help is appreciated!
+6Can you describe your schema a little more? Looks like you have:
If markup is set at the service level, can you invoice at the service level instead of lineitems? This would allow you to rollup the service markups at the invoice. Another alternative would be to shift markup from service table to lineitem table, then markup can be rolled up from lineitem->invoice table. I might be misinterpreting what you're trying to do though.
+6Can you describe your schema a little more? Looks like you have:
If markup is set at the service level, can you invoice at the service level instead of lineitems? This would allow you to rollup the service markups at the invoice. Another alternative would be to shift markup from service table to lineitem table, then markup can be rolled up from lineitem->invoice table. I might be misinterpreting what you're trying to do though.
Current Base:
I'm not sure how to capture the profit value based off the markup of said products. Maybe you are explaining it, and I'm just not understanding it. I have the "services cost" & "markup" statically set to a figure. Markup amount is service cost*markup giving that amount.
Line items table: I have the "Amount" column lookup based off the "selling price". When I scroll over to "Create Invoice," I'm wanting to generate my line items, qty etc and then have a column showcasing the profit of this invoice - but again, I'm not sure how to formulate that. But I may not be explaining it. Haha.
Thanks again for the help!
+31Current Base:
I'm not sure how to capture the profit value based off the markup of said products. Maybe you are explaining it, and I'm just not understanding it. I have the "services cost" & "markup" statically set to a figure. Markup amount is service cost*markup giving that amount.
Line items table: I have the "Amount" column lookup based off the "selling price". When I scroll over to "Create Invoice," I'm wanting to generate my line items, qty etc and then have a column showcasing the profit of this invoice - but again, I'm not sure how to formulate that. But I may not be explaining it. Haha.
Thanks again for the help!
Hm, if you created a rollup of the "Markup Amount" field with "SUM(values)", that would be the profit, right?
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.