Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Num(Round(Sum({$<StoreCode = {'WSDP'}>} SalesPrice*TransactionQuantity)) - Sum({$<StoreCode = {'WSDP'}>}GrossValue-DiscountValue),'€ #.##0,00')
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',',','.')