Forum Discussion

KorrieClark's avatar
Qrew Trainee
3 years ago

Numeric equivalent of "List" formula

I figured this would be easy but i can't get it to work, basically I'm looking to list numeric values possibly with a tag. 

Basically I have two fields, lets call them Boys and Girls both numeric values
I want to show them in one field in a calendar view as: "Boys: 5, Girls: 2"

I figured you could do some kind of List("," "Boys:"[Number of Boys], "Girls:" [Number of Girls]) 
but since they're numeric it doesnt work- is there anything similar to this that will do what i want?

Korrie Clark

2 Replies

  • PaulPeterson1's avatar
    Qrew Assistant Captain
    You can try something like this:

    List("," "Boys:" & ToText([Number of Boys]), "Girls:" & ToText([Number of Girls]) )

    Paul Peterson
    • KorrieClark's avatar
      Qrew Trainee

      That worked, thanks!



      Korrie Clark | Manager- Business Processes


      TransPerfect Staffing Solutions

      1717 Main St

      Dallas, TX 75201

      t. 214-744-4200 | m. 917-882-6894



      Visibility. Predictability. Clarity.