Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String + a number (Expression syntax problem)

Hi guys,

I'm trying to write something like this...
Total sales: num(sum( {$<Region= {'Tristate'} >} [Sales] ),'##,###.##')

Where total sales: is a string. How do I form them together? I would like to display it in a textbox!


Thanks for anyone who can help!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

= 'Total sales: ' & num(sum( {$<Region= {'Tristate'} >} [Sales] ),'##,###.##')


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

= 'Total sales: ' & num(sum( {$<Region= {'Tristate'} >} [Sales] ),'##,###.##')


talk is cheap, supply exceeds demand