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
Solved! Go to Solution.
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(...))))
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |