Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jfrick100
Starting Member
1 Post |
 Posted - 2012-02-15 : 18:16:10
|
| We are having issues formatting Revenues and Costs in accordance with how the financial staff wants to see them. For example:Revenue $100Costs $20Profits $80Notice that all are shown as positive, but obviously Costs are subtracted from Revenues.Now this is a simple example, but we have much more complicated reporting with subtotals within subtotals, and the financial staff wants all numbers to show as positive even though some are actually negative, at least in the sense that they reduce a subtotal.Any ideas how to do this?James F |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2012-02-15 : 18:51:57
|
| Formatting should be done on the front end, not in the database..Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-02-15 : 20:28:37
|
use ABS() ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Doing Financial Reporting in SQL