Margin Calculations

I'm asked from time to time to do margin calculations, especially in reporting.

After looking this up 3 times a year for forever (smiles) I'm just going to create a post so I'll have it.

The value of this article is in the menu structure (above). Follow the link that says 'This article, and all our great SQL (General) documentation'... and remember where it is for when you need it.


Calculate Business Days
CHARINDEX/PATINDEX
Copy ALL the data from one database to another
CROSS APPLY example
CTE Example
CTE Example showing multiple sources, ddv_401k
CTE Example showing Recursion
dd_FL
DELETE into an OUTPUT table
EXCEPT in SQL triggers for Dynamics GP
FORMAT - examples of date formatting
FORMAT - Format a number
FORMAT - Format a number as a percent
FORMATMESSAGE (SQL equivalent to String.Format)
Margin Calculations
RAISERROR - formatting the error string
Running Sum
SQL Bulk Insert
SQL Pivot code
SQL Stuff

... and you 'll find more on the SQL (General) Menu

--margin calculations

DECLARE @cost Numeric(19,5) = '100'

DECLARE @price Numeric(19,5) = '142.86'

--formula to get the actual margin from cost and price

SELECT actualmargin = (@price - @cost) / @price

DECLARE @intendedMargin Numeric(19,5) = .30

--formula to get the price from the cost and intended margin

SELECT price = @cost / (1 - @intendedMargin)

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.

Links
Home
Knowledge Areas
Sitemap

Contact

Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences

Margin Calculations

Related Articles

... and you 'll find more on the SQL (General) Menu