Problem with an expression...(Calculation)

[#1]

Hi there,

I have a data field labeled "Document Type" with eight different values, each value corresponding with a document type. I need to define an expression that counts the number of two different document types which are in the same field , and then divides them to get a ratio between them.

Any ideas?

Thanks in advance...

[johnw · Accepted solution]

Maybe this?

count({<"Document Type"={'Type A'}>} "Document")
/count({<"Document Type"={'Type B'}>} "Document")

[#3]

Excelent, it works!

thanks a lot John

[#4]

count( {< [Document Type] ={'A'} >} value)
/
count( {< [Document Type] = {'A','B'} >} value)

... and...

count( {< [Document Type] ={'B'} >} value)
/
count( {< [Document Type] = {'A','B'} >} value)