Euro sign in text object

[#1]

Hello all,

the current sales for Diamond Point.nl in a text object looks like this:

i am using the current expression to show 5710:

=round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity))

My wish is to show €5710 is this text object. which expression should i use ?

Thanks.

Greets,

Rega

[Anonymous]

You probably need to use the Chr() function and the decimal ascii for € of 8364, so maybe something like :

=chr(8364) & round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity))

[sunny_talwar · Accepted solution]

May be this:

Num(Round(Sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity)), '€#,###.0')

[engishfaque]

Dear Rega,

Use listed below expressions according to your requirement.

Expression1:

=Num(round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity)), '€#,##0.00')

Expression2:

=Num(round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity)), '€#,##0')

Kind regards,

Ishfaque Ahmed

[swuehl]

If you are fine with the default money format as defined in your script:

=Money( round(sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity) )

[engishfaque]

Dear Rega,

If you are going to use Money function such as suggested by @Stefan then you need to make change on your edit script Main tab and place this money format:

SET MoneyFormat='€#,##0.00;(€#,##0.00)';

Kind regards,

Ishfaque Ahmed

[#7]

Thanks All !