Why do you need to use a calculation field to merge your values?
Could you use merge fields in a text block on your layout instead?
If you can, then you can use Data formatting specified in the inspector to produce the needed data formats.
Hey Phil Thanks for the suggestions
The reason i'm using merge fields in a calculation is because i want them to be empty when they are blank. that way my move up formating will format them properly. i still need to label them as i'm placing many different fields in the one merge field. its all working however the numbers displayed from the fields wont format with commas. i've tried setting them up in the inspector and it does nothing
hope that makes sense
Thanks for your help
This looks like data that would be more easily displayed as a set of records in a portal.
But sticking with your current design in order to answer the question:
NumToJText, while intended for use with Japanese language characters, can be used to insert a comma as a thousands separator:
NumToJText ( 1234 ; 1 ; 0 )
Will return: 1,234