How to write 2 expressions into a measure in a table

bhanukoppera7491 — Mon, 20 Dec 2021 21:38:40 GMT

Hi,

I was wondering how to write multiple expressions in to a single measure.

I want to display

Country Sales

USA $130 (5.6%)

India $124(2.6%)

I tried to write an expression

sum(Sales) & '(' & sum(Target) &')'

which is not working. Can you please help me out.

Re: How to write 2 expressions into a measure in a table

Mattie — Thu, 06 Feb 2020 14:17:18 GMT

Try this:

sum(Sales) & NUM(sum(Target), ' (#,##%)')