Add a comma for the thousand's place in a text function
Is it possible to add a comma for the thousand's place in a text function?
Have one in particular in mind?
Home > Reference > Functions reference > Text functions
I am using the List Function which includes number fields, and would like the number fields to display with a comma.
If a number is all that you are extracting, specify number as your calculation's return type and use the inspector's data tab to specify dataformatting with a thousands separator.
I apologize for not explaining my situation clearer. I have a group of numbered type fields (ex:Field 1, Field 2, Field 3, etc...). I amcreating a list – using the List Function which includes each of the numberfields. Unfortunately a List Function resultsin a Text. Therefore, the number fieldsdisplayed do not include the thousand comma separator. I need a way to add the comma separator.
Let ( [ N = YourNumberField ; i = Int ( N ) ; Ge1000 = Floor ( i / 1000 ) ; Lt1000 = i - Ge1000 * 1000 ] ; If ( Ge1000 ; Ge1000 & "," & Right ( "00" & Lt1000 ; 3 ) ; Lt1000 ) & If ( N ≠ i ; N - i ) )
Retrieving data ...