Price format and decimal points

Is there a way to show the decimal points in a price of a display name?
3X_f_4_f4c84668f108f7e1ac96f5b84a24f41f8dcb57b4.png

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

3X_e_8_e84bd0b32970967fe366831a617f7ad75d44f462.png

Solved Solved
0 4 953
1 ACCEPTED 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(...))))

View solution in original post

4 REPLIES 4

Steve
Participant V

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

Top Labels in this Space