Protour Travel Posted June 20, 2013 Share Posted June 20, 2013 Is there a way to place a comma in the Capacity line? Thanks!  TextSize (TextStyleAdd ( Clients::Name; Uppercase + Bold); 18 ) & TextSize ( TextStyleAdd (" ("& TypeDay &")"; Uppercase); 18) & ¶ & TextSize ( TextStyleAdd ( Print_CityCSState;Uppercase ); 14) &¶ & TextSize ( TextStyleAdd ( Venue; Uppercase); 14) & ¶ & TextSize ( If (not IsEmpty ( Capacity ); "Capacity: " & GetAsNumber ( Capacity );If (not IsEmpty ( Venue ); "Capacity: Unknown"; "")); 12)  Link to comment Share on other sites More sharing options...
David Jondreau Posted June 20, 2013 Share Posted June 20, 2013 Replace TextSize ( If (not IsEmpty ( Capacity ); "Capacity: " & GetAsNumber ( Capacity );If (not IsEmpty ( Venue ); "Capacity: Unknown"; "")); 12) with TextSize ( If (not IsEmpty ( Capacity ); "Capacity: " & GetAsNumber ( Capacity ) & "," ;If (not IsEmpty ( Venue ); "Capacity: Unknown"; "")); 12) Link to comment Share on other sites More sharing options...
brian rich Posted June 20, 2013 Share Posted June 20, 2013 You could add a custom function such as formattedNumber() to do this for you. This custom function can be found at http://www.briandunning.com/cf/451 Then your calculation becomes: TextSize (TextStyleAdd ( Clients::Name; Uppercase + Bold); 18 ) & TextSize ( TextStyleAdd (" ("& TypeDay &")"; Uppercase); 18) & ¶ & TextSize ( TextStyleAdd ( Print_CityCSState;Uppercase ); 14) &¶ & TextSize ( TextStyleAdd ( Venue; Uppercase); 14) & ¶ & TextSize ( If (not IsEmpty ( Capacity ); "Capacity: " & formattedNumber(Capacity;",";""); If (not IsEmpty ( Venue ); "Capacity: Unknown"; "")); 12) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3970 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now