Notes View Issue

HCL Domino Domino Forum
1

I’ve read all the postings and I don’t think this is possible, but I need to check with you guys . I have attempted different ways but no succes.

I have view with 4 colums, this view getting all documents which is created by using one particular form called “Contracts”.

Column 1 has Contract type which displays

Main Contract

Sub Contract

Column to has Contract Status which displays

Won

Lost

in this column i need to display only staus"Won".

Column 3 has Date which displays Contract won date

01/01/10

02/02/10

02/02/10 like this

Column 4 i need to write formula for calculation like

Total documents in col1/Tot no docs in col2 *100

Based on this i will get some percentage, how to achive this.Any Help really appreciated

2

Subject: filter in view selection?

Why can’t you try filtering in view selection formula? something like - Select Form = “Contracts” & Contractstatus=“Won”

This will give only documents that are with contractstatus “Won”. Just a try. Not sure if this view is used in other places which would have an impact.