Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 14, 2023 11:49 AM - edited Jul 14, 2023 12:00 PM
Hey 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!
Jul 14, 2023 01:31 PM
Can 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.
Jul 15, 2023 12:18 AM - edited Jul 15, 2023 01:41 PM
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!
Jul 15, 2023 03:46 AM
Hm, if you created a rollup of the "Markup Amount" field with "SUM(values)", that would be the profit, right?