Moneyformat in textobject issue

[#1]

hello guys,

How can i get a result (see image below) in the text object properties like:  €64.992,25 .

my current expression as text:

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

which expression should you guys recommend?

Greets,

Rega

[sunny_talwar]

Try this:

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

[swuehl]

I think you may need to check also the format code, if you want two decimals (and I would probably remove the Round() function, but that's up to your requirements):

=Num(

Round(Sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity)) - Sum({$<StoreCode = {'WSDP'}>}GrossValue-DiscountValue)

,'€ #.##0,00',',','.')