Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
sum(Sales) & NUM(sum(Target), ' (#,##%)')