adding "(" before an expression in a text object

Mon, 24 Mar 2014 17:57:35 GMT

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

Re: adding "(" before an expression in a text object

jaimeaguilar — Mon, 24 Mar 2014 17:58:42 GMT

Hi,

try like this:

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

regards