cancel
Showing results for 
Search instead for 
Did you mean: 

Show negative numbers as ()

BrianLittlemore
Rocketeer

Apparently Incorta v6 still does not include the ability to show negative numbers in brackets i.e. (123) not -123

Our finance users are REALLY annoyed that this isn’t a standard feature !

Does anyone have any advise on how / if this can be done

And can it be included in the development plan please.

1 REPLY 1

JoeM
Community Manager
Community Manager

Hi Brian - 
A solution today could be using the following formula to format. 

case(
	NegativeNumbers.Sample.Profit < 0, 
	'(' + abs(
		NegativeNumbers.Sample.Profit
	) + ')', 
	string(
		NegativeNumbers.Sample.Profit
	)
)

 That being said, I think it is worth considering adding to our format options. Adding @Prince for review.