topic Re: Show negative numbers as () in Dashboards & Analytics Discussions

Show negative numbers as ()

BrianLittlemore — Mon, 18 Sep 2023 10:29:17 GMT

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.

JoeM — Tue, 19 Sep 2023 17:51:53 GMT

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.