Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
,'##.##%')
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)
,'##.##%')
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)
,'##.##%')