3 Replies Latest reply on Nov 11, 2013 11:33 AM by philmodjunk

    thousands comma in a merge field



      thousands comma in a merge field


           hello everyone 

           need some help with a merge field 

           i have a calculation merge field that displays multiple fields within, what im trying to do is get the thousands separator to show up in the calculation field. it will display the decimal just not the thousands ???? and ideas 

           my code is as follows 

           If ( IsEmpty ( BaseTicketPrice1 ) 
           ;"P1 Base: $" & BaseTicketPrice1 & 
           "     P1 Gross: $" & GrossTicketPriceRes1 & 
           "     P1 Capacity: " & CapacityPriceRes1 & 
           "     P1 total: $" & CapacityPriceRes1 * GrossTicketPriceRes1 )
           All the Fields above have been formated to show the thousands comma and decimal they just don't display in preview 
           See attached Screen shot 
           Thanks for your help with this 


        • 1. Re: thousands comma in a merge field

               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.

          • 2. Re: thousands comma in a merge field

                 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 


            • 3. Re: thousands comma in a merge field

                   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