topic Re: Moneyformat in textobject issue in QlikView

Moneyformat in textobject issue

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Moneyformat in textobject issue

sunny_talwar — Tue, 03 May 2016 14:24:35 GMT

Try this:

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

Re: Moneyformat in textobject issue

swuehl — Tue, 03 May 2016 15:12:18 GMT

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',',','.')