Forum Discussion

KorrieClark's avatar
KorrieClark
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
------------------------------
  • PaulPeterson1's avatar
    PaulPeterson1
    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
      KorrieClark
      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

       

      www.transperfectlegal.com

       

      Visibility. Predictability. Clarity.