Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

set analysis

Hello I would like to have the number of Files who don't have a Docs related (the - ones)

Thank you

FileDocs.PNG

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count(DISTINCT File) - Count(DISTINCT {<Doc = {"*"}>} File)

or

Count(DISTINCT {<File = {"=Len(Trim(Doc)) = 0"}>} File)

View solution in original post

3 Replies
Anonymous
Not applicable

NullCount(Docs) ??

satheshreddy
Creator III
Creator III

Hi Zied,

try like the bellow.

count({<Docs={''}>}File)

Regards

Sathish

sunny_talwar

May be this

Count(DISTINCT File) - Count(DISTINCT {<Doc = {"*"}>} File)

or

Count(DISTINCT {<File = {"=Len(Trim(Doc)) = 0"}>} File)