How to put Dollar sign

[AH]

Hi I have textbox which provides me some amount in dollar. I want to put a $ sign before the price amount. the expression behind the text box is:

=num(Sum({<[ItemID] = {'SA', 'CP' }>} TotalInvoiceInFunCur),'##,##0')

Thanks,

Shan

[oscar_ortiz · Accepted solution]

Simply try:

=num(Sum({<[ItemID] = {'SA', 'CP' }>} TotalInvoiceInFunCur),'$##,##0')

Good luck

Oscar

[its_anandrjs]

Hi,

Try like

='$'&num(Sum({<[ItemID] = {'SA', 'CP' }>} TotalInvoiceInFunCur),'##,##0')

Regards

Anand

[AH]

Thanks Guys. Both way it works.

Regards

Shan