Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
At this moment i want to have a correct € format in the red markered text object value, but i dont get the format €18.685,58.
The current expression of this text object is:
=Num(Round(sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>} SalesPrice*TransactionQuantity))
- Sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue))
-
Num(round(sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}TransactionQuantity*SalesPrice))
- sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue),'€ #.##0,')
which expression do i have to change to get €18.685,58 ?
thanks.
Try
=Num(
Round(sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>} SalesPrice*TransactionQuantity))
- Sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue)
-
Round(sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}TransactionQuantity*SalesPrice))
- sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue)
,'€ #.##0,',',','.')
i.e. one num() function that formats the complete calculations (recheck the brackets)
=Num(Round(sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>} SalesPrice*TransactionQuantity))
- Sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue)
-
round(sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}TransactionQuantity*SalesPrice))
- sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue),'€ #.##0')
Hi Rega,
Check this little change:
=
Num(
Num(Round(sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>} SalesPrice*TransactionQuantity))
- Sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue))
-
Num(round(sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}TransactionQuantity*SalesPrice))
- sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue))
, '€ #.##0,00')
Regards,
MB
Miguel is right, the format code should show the two decimals.
But your original issue is that you have used different / missing formatting functions on the aggregations, while you should do a final formatting for the result of your calculation.