nicedone
asked on
i have a lotus notes view that has categories and sub categories and then documents, i want to calculate the number of documents in each subcategory that has a specific field value inside document.
Hi,
I have a view that has categories-->subcategories -->documen ts
what I need to calculate is the number of documents in each subcategory that has a specific field value.
I can make a Total column but that is not what I am looking for.For example a subcategory has 20 documents underneath total gives me 20 .but in that document i want to check some field's value if this field is empty in 1 document then it should give me 19 or if 13 documents underneath that subcategory has a field A=""(field A empty) then i want to calculate 7 instead of 20 because 13 documents has empty field A.
How can i achieve it in a easy way?
Tnx...
I have a view that has categories-->subcategories
what I need to calculate is the number of documents in each subcategory that has a specific field value.
I can make a Total column but that is not what I am looking for.For example a subcategory has 20 documents underneath total gives me 20 .but in that document i want to check some field's value if this field is empty in 1 document then it should give me 19 or if 13 documents underneath that subcategory has a field A=""(field A empty) then i want to calculate 7 instead of 20 because 13 documents has empty field A.
How can i achieve it in a easy way?
Tnx...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER