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(...))))
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(...))))
Yes!, it worked thanks
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |