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.
Posted on 2012-12-23
I have a view that has categories-->subcategories-->documents
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?