Displaying text value with Sum value in Text box

[#1]

Hi QV

I want  to show the sum of values in text box text (likeNo Of Receipts--250)......will it work??

No Of Receipts &'-'& Sum(RECEIPT_CNT)

[#2 · Accepted solution]

= 'No Of Receipts' &'-'& Sum(RECEIPT_CNT)

This will work

[#3]

can we use multiple fileds like below??

='OTD%' &'-'& Sum(MET_OTD_RQST_CNT), 'Short Cycle%' &'-'& Sum(SHRT_CYC_CNT) , 'Request Met' &'-'& Sum(MET_RQST_CNT)

getting some garbage after expression issue.

[#4]

got it tnax

=('OTD%' &'-'&

Sum(MET_OTD_RQST_CNT) &'-'& 'Short Cycle%' &'-'& Sum(SHRT_CYC_CNT) &'-'& 'Request Met' &'-'& Sum(MET_RQST_CNT) )

[anbu1984]

Yes you can. But use ampersand instead of comma

='OTD%' &'-'& Sum(MET_OTD_RQST_CNT) & 'Short Cycle%' &'-'& Sum(SHRT_CYC_CNT) & 'Request Met' &'-'& Sum(MET_RQST_CNT)