how to sum and divide expressions with set analysis

[kylealpaugh]

i have two expressions that i would like to add together and then divide by the total number to find a percent of automated orders how would i do this.

=num(sum(count({<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Pur. ord. type_BSARK_line]={'EDI','XML'}, [Order Document Type_AUART_line]-={'QT'},[Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line)

+

Count ({<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Order Document Type_AUART_line]={ZWEB}, [Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line))

/

count({<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Pur. ord. type_BSARK_line]=, [Order Document Type_AUART_line]-={'QT'}, [Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line),'##.##%')

this is my expression how can i fix it to work

[vishsaggi · Accepted solution]

Try this?

=Num(
Rangesum(count({<Source={'Billing'}, RejectionReason_ABGRU_line={' '}, [Pur. ord. type_BSARK_line]={'EDI','XML'}, [Order Document Type_AUART_line]-={'QT'},[Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line)
,
count({<Source={'Billing'}, RejectionReason_ABGRU_line={' '}, [Order Document Type_AUART_line]={ZWEB}, [Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line))
/
count({<Source={'Billing'}, RejectionReason_ABGRU_line={' '}, [Pur. ord. type_BSARK_line]=, [Order Document Type_AUART_line]-={'QT'}, [Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line)
,'##.##%') 

[sasiparupudi1]

May be try

Num(

Count(

{

<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Pur. ord. type_BSARK_line]={'EDI','XML'}, [Order Document Type_AUART_line]-={'QT'},[Company Code_BUKRS]={'1100','1500'}>

+

<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Order Document Type_AUART_line]={'ZWEB'}, [Company Code_BUKRS]={'1100','1500'}>

}

distinct %OrderDocumentItem_Key_line

)

/

count({<Source={'Billing'}, RejectionReason_ABGRU_line={" "}, [Pur. ord. type_BSARK_line]=, [Order Document Type_AUART_line]-={'QT'}, [Company Code_BUKRS]={'1100','1500'}>} distinct %OrderDocumentItem_Key_line)

,'##.##%')