Reverse sign for display only?

[dwh1104]

Is there a way to "reverse sign for display only" as you can in Crystal Reports?

I would like to show my revenue and expenses as a positive number, but would like the end result to still give me the correct bottom line.

Example:

Now...

Revenues = $1500.00

Expenses = ($1000.00)

Net Income = $500.00

Would like to see...

Revenues = $1500.00

Expenses = $1000.00

Net Income = $500.00

Of course, there would be several lines that make up the revenues and expenses.

Any suggestions?

Thanks, Dan

[boorgura]

Hey Dan,

you can use the number formatting in the UI by:

num(<field_name> , '($#,##0.##)')

Thanks,

Rocky

[Oleg_Troyansky]

I'd say - the other way around... Typically amounts are formatted as the following:

$#,##0.00;($#,##0.00)

You can format both positive and negative numbers the same way:

$#,##0.00;$#,##0.00

This way, negative amounts will always appear as positive, but they will still get calculated as negative.

[dwh1104]

Let's say that the expenses are greater than the revenues, I would still want the Net Income (or Total) to be displayed as a negative. See example below.

Income Statement Level	Amount	=Sum([GL Line Amount])
GROSS REVENUE	$4,554.00	$4,554.00
PURCHASED SERVICES	$253.83	($253.83)
SALARIES & FRINGE BENEFITS	$15,556.22	($15,556.22)
Net Income	$20,364.05	($11,256.05)
	This is the way I would like the amounts to display, but the Net Income is wrong.	In this column, the Net Income is correct.

Is this possible?

Thanks for all replies.

[dwh1104 · Accepted solution]

This can be done by incorporating the dimensionality() function in the expression.