Hello all,
I want to display million values with apostrophe. I already tried this solution; Apostrophe as thousand seperator But it didn't work for me. I tried to change data type and I used it in calculated field, but it didn't also work. How can I solve this problem?
For example:
93,000,000 -> 93'0
500,000 -> 0'5
37,500,000-> 37'5
Thanks in advance.
Actually, here's an alternative solution which seems to work. First create the following calculated field:
Value Rounded String
// Round the value to the proper spot and convert to string
STR(ROUND([Value],-5))
And change Millions with Apostrophe to the following:
Millions with Apostrophe
// Parse the value and insert ' where appropriate
IF LEN([Value Rounded String]) <= 6 THEN
LEFT(REPLACE(SPACE(7-LEN([Value Rounded String]))," ", "0") + "'" + [Value Rounded String], 3)
ELSE
LEFT([Value Rounded String], LEN([Value Rounded String])-6) + "'" + MID([Value Rounded String], LEN([Value Rounded String])-5, 1)
END
