adding text and formula in text object

[marksmunich]

i want to add text and 2 formulas which display the calcualted value in 2 rows in a text object

for ex: no of cities: 3456

           no of states: 345

back bround in the text object will be like  = count(cities)

but how to make it work for both text and 2 formulas in the same text object

T&R

Mark

[marksmunich]

found answer.

[sujeetsingh]

=sum(Fact1)  & Sum(Fact2) &'Text Message '

try this

[#4]

=count(cities) &  chr(10) & count(states)

[marksmunich]

for one expression its working, how can i calculate for 2 expressions in sam text object

[#6 · Accepted solution]

try this

='Number of cities =  '  & count(cities) &  chr(10) & 'Number of states=  ' & count(states)