Skip to main content
Question

Numeric equivalent of "List" formula

  • February 22, 2022
  • 0 replies
  • 105 views
Forum|alt.badge.img+3
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
------------------------------
This topic has been closed for replies.

  • PaulPeterson1
  • Registered
  • February 22, 2022
You can try something like this:

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

------------------------------
Paul Peterson
------------------------------
Terms & ConditionsAccessibility statement