Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Maybe this?
count({<"Document Type"={'Type A'}>} "Document")
/count({<"Document Type"={'Type B'}>} "Document")
Maybe this?
count({<"Document Type"={'Type A'}>} "Document")
/count({<"Document Type"={'Type B'}>} "Document")
Excelent, it works!
thanks a lot John
count( {< [Document Type] ={'A'} >} value)
/
count( {< [Document Type] = {'A','B'} >} value)
... and...
count( {< [Document Type] ={'B'} >} value)
/
count( {< [Document Type] = {'A','B'} >} value)