adding "(" before an expression in a text object

[#1]

Hi,

below is my expression

=if(sum(Sales)>1000000,num(Sum(Sales)/1000000,'$ ###0 MM'),num(Sum(Sales)/1000,'$ ###K'))

i want to add "(" before the output and ")" post the output.

Eg: current output is 100MM

I want it to be (100MM)

Thanks

[jaimeaguilar · Accepted solution]

Hi,

try like this:

='(' & if(sum(Sales)>1000000,num(Sum(Sales)/1000000,'$ ###0 MM'),num(Sum(Sales)/1000,'$ ###K')) & ')'

regards