CODEWITHSUNDEEP
lotus-notescalculated-columnsnotesview
Inchman
Inchman

Reputation: 25

Combining values in a Notes/Domino column that is categorized

I have a notes view that shows hundreds of peoples’ ages. I then created a categorized view so I can see how many people are in each age. This works fine.

Problem is, I want to group these ages into five year brackets (I.e. age 0 to 5, 6 to 10,11 to 15,etc) The field is called ‘age’ and it is a text field.

Is there an easy way to do this?

Thanks in advance.

Upvotes: 1

Views: 55

Answers (1)

Ken Pespisa
Ken Pespisa

Reputation: 22266

A simple, brute-force way is to create a formula for your column that is categorized. 

@If(Age <= 5; "0 to 5";
      Age > 5 & Age <= 10; "6 to 10";
      Age > 10 & Age <= 15; "11 to 15";
      ....
      Age > 100; "Over 100"; "Not specified");

Also, I believe you could create a hidden Age column before this one and sort by it to make the categories appear in age order

Upvotes: 2

Related Questions