If( GetAsNumber(Number of Children) = 1; "child"),
If( GetAsNumber(Number of Children) > 1; "children")
Assuming that the field is a calculation field with text result:
Case (GetAsNumber (Number of Children) = 1; "Child" ;
GetAsNumber (Number of Children) > 1; "Child";
default result )
Note that the default result is what happens if both tests fail, like if there are no children.
Is this what you're after?
If( GetAsNumber(Number of Children) = 1; "child";"children")
That's a fully resolved If stmt in a calc that will get you what you need (I tried it and it works): It will say "child" only if there is one child, otherwise it returns "children" which is what you want when there are no children or many children (note my use of the words child and children in describing it and you should see why it works). Right?
Let ( n = NumberofChildren; If ( n; "Child" & Case ( n > 1; "ren" ) ) )
Thanks so much, everyone! This group is awesome. I'm so glad I joined. Hopefully I can help someone one day :-)