Price format and decimal points

Is there a way to show the decimal points in a price of a display name?

I tried putting the value to sum with the DECIMAL () expression but it doesn’t work

I also wanted to know if there is any way that in the chart aggregate piechart, a price value can be displayed also with the decimal points

Could you explain a little more, because I don’t understand how the text expression could help

TEXT() converts a raw value into its textual “display format”, which should include a decimal point and thousands separators. Try wrapping it around your SUM() expression:

CONCATENATE(...,
TEXT(SUM(SELECT(...))))

3 Likes

Yes!, it worked thanks

1 Like