How do i format numbers within calculations to have the thousand seperator?
TextStyleAdd allows you to format text, but how do I format numbers within a calculation to have the thousand seperator?
Pick "Currency" in the Inspector and it'll give you the option.
This is found on the data tab in the inspector.
You normally do not need to apply such formatting within the calculation unless you are either exporting the data with the format or including the field as a merge field in a block of text that includes other number merge fields that cannot have the same formatting.
I'm including the information in a block of text that contains other merge fields that cannot have the same formatting.
Currency in the Inspector is not applicable in this situation.
I need to format the information within the calculation with a thousand separator.
NumToJText ( number ; 1 ; 0 )
This one could even be used with decimal numbers, till two decimals:
Raybaudi, I am always impressed by your creative use of Arcane FileMaker functions. I've added this tidbit to my database of useful tricks.
"your creative use of Arcane FileMaker functions"
I have stolen that one to my belgian-french friend Fabrice Nordmann.
Thank you Raybaudi & Phil.
I'll give them a try and decide which works best for me.
Retrieving data ...