developerWorks

AIX and UNIX
Information Mgmt
Lotus
	New to Lotus
	Products
	How to buy
	Downloads
	Live demos
	Technical library
	Training
	Support
	Forums & community
	Events
Rational
Tivoli
WebSphere

Java™ technology
Linux
Open source
SOA and Web services
Web development
XML

My developerWorks
About dW
Submit content
Feedback

developerWorks > Lotus > Forums & community > IBM Lotus Notes/Domino 8.5 Forum (includes Lotus Notes Traveler)

IBM Lotus Notes/Domino 8.5 Forum (includes Lotus Notes Traveler)

Subject: Fun with categorized views

Feedback Type: Problem

Product Area: Notes Client

Technical Area: Application Development

Platform: Windows

Release: 8.5.3

Reproducible: Always

Hi all

Even tho I've been building Notes apps for many years, I have a very simple issue which has me stumped.

I'm building a view that shows how long and how many 'tickets' have remained open. The categorized column formula is relatively simple:

x:=@Integer((@Created - @Today)/86400);
@If( @IsError( x ); 0; @SetField("tmp";@Abs(x)));
@If(
tmp = 1; "Open 1 day";
tmp > 1 & tmp <=5; "Open 1 to 5 days";
tmp > 5 & tmp <=10; "Open 6 to 10 days";
tmp > 10 & tmp <=30; "Open 10 to 30 days";
"Open > 30 days")

Here's what I'm seeing:

9 Open 1 day
10 Open 1 to 5 days
13 Open 6 to 10 days
3 Open > 30 days
13 Open 10 to 30 days
9 Open > 30 days
6 Open > 30 days
1 Open > 30 days
4 Open > 30 days

Note how the 'Open > 30 days' repeats. I was expecting this last category to simply show all the entries collected together. I'm confused. Any ideas?

thanks!
clem

Feedback number WEBBAYMPGZ created by Clem Padin on 05/10/2018

Status: Open
Comments:

Return to top

Fun with categorized views (Clem Padin 10.May.18)

. . Try this (Carl Tyler 10.May.18)

. . . . Same behavior (Clem Padin 11.May.18)

. . Hm. What are the attributes & other... (Mike Woolsey 14.May.18)

. . . . same in other dbs (Clem Padin 15.May.18)

Printer-friendly

Search this forum

Member Tools

RSS Feeds

RSS feeds

	All forum posts RSS
	All main topics RSS
	More Lotus RSS feeds

Resources

	Forum use and etiquette
	Native Notes Access
	Web site Feedback

Lotus Support

	IBM Support Portal - Lotus software
	Lotus Support documents
	Lotus support by product
	Lotus support downloads
	Lotus support RSS feeds

Wikis

	IBM Composite Applications
	IBM Mashup Center
	IBM Connections
	IBM Connections Cloud Developers
	IBM Docs
	IBM Forms
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud for Social Business
	IBM Web Experience Factory
	Lotus Domino
	Lotus Domino Designer
	Lotus Expeditor
	Lotus Foundations
	Lotus iNotes
	Lotus Instructor Community Courseware
	Lotus Notes
	Lotus Notes & Domino Application Development
	Lotus Notes Traveler
	Lotus Protector
	Lotus Quickr
	Lotus Symphony
	IBM Web Content Manager
	WebSphere Portal

Lotus Forums

	Notes/Domino 9.0
	Notes/Domino 8.5 + Traveler
	Notes/Domino XPages development forum
	Notes/Domino 8
	Notes/Domino 6 and 7
	IBM Connections
	IBM Mobile Connect
	IBM Sametime
	IBM SmartCloud Notes
	Lotus Enterprise Integration
	Lotus Protector
	Lotus Quickr
	Lotus SmartSuite