topic Re: Calculation for subtracting margin in QlikView https://community.qlik.com/t5/QlikView/Calculation-for-subtracting-margin/m-p/463363#M484622 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Subtract 35% of the result of the expression? So that 65% remains?</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><STRONG>0.65*</STRONG>(Sum({1&lt;LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'TirePower'}, Locations.CorporateOfficeFlag={0},Locations.TirePowerID-={1,9}, TPCustomerInvoicesDetails.TransactionDetails.DET_TransTypeID={1, 17} &gt;}[Gross Revenue])</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">+</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Sum({1&lt;LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'MaddenCo'}, IncludeInUnitsSoldProdClassFlag={1},IncludeInUnitsSoldPrdClass47Flag={1}, MaddenCoCustomerClass-={5,9},IncludeInUnitsSoldProdClassFlag={1},Locations.TirePowerID-={1,9} &gt;}[Gross Revenue]))</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">/4</P></BODY></HTML> Wed, 15 May 2013 17:31:36 GMT Gysbert_Wassenaar 2013-05-15T17:31:36Z Calculation for subtracting margin https://community.qlik.com/t5/QlikView/Calculation-for-subtracting-margin/m-p/463362#M484621 <HTML><HEAD></HEAD><BODY><P>I have the following expression:</P><P></P><P>(Sum({1&lt;LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'TirePower'}, Locations.CorporateOfficeFlag={0},Locations.TirePowerID-={1,9}, TPCustomerInvoicesDetails.TransactionDetails.DET_TransTypeID={1, 17} &gt;}[Gross Revenue])</P><P>+</P><P>Sum({1&lt;LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'MaddenCo'}, IncludeInUnitsSoldProdClassFlag={1},IncludeInUnitsSoldPrdClass47Flag={1}, MaddenCoCustomerClass-={5,9},IncludeInUnitsSoldProdClassFlag={1},Locations.TirePowerID-={1,9} &gt;}[Gross Revenue]))</P><P>/4</P><P></P><P>Sum of Gross Revenue from 2 different sources, dividing by 4...</P><P></P><P>I need to subtract 35% margin</P><P></P><P>Does anyone have any suggestions on how to properly write this expression?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Wed, 15 May 2013 16:50:21 GMT https://community.qlik.com/t5/QlikView/Calculation-for-subtracting-margin/m-p/463362#M484621 jenmclean 2013-05-15T16:50:21Z Re: Calculation for subtracting margin https://community.qlik.com/t5/QlikView/Calculation-for-subtracting-margin/m-p/463363#M484622 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Subtract 35% of the result of the expression? So that 65% remains?</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"><STRONG>0.65*</STRONG>(Sum({1&lt;LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'TirePower'}, Locations.CorporateOfficeFlag={0},Locations.TirePowerID-={1,9}, TPCustomerInvoicesDetails.TransactionDetails.DET_TransTypeID={1, 17} &gt;}[Gross Revenue])</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">+</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Sum({1&lt;LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'MaddenCo'}, IncludeInUnitsSoldProdClassFlag={1},IncludeInUnitsSoldPrdClass47Flag={1}, MaddenCoCustomerClass-={5,9},IncludeInUnitsSoldProdClassFlag={1},Locations.TirePowerID-={1,9} &gt;}[Gross Revenue]))</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">/4</P></BODY></HTML> Wed, 15 May 2013 17:31:36 GMT https://community.qlik.com/t5/QlikView/Calculation-for-subtracting-margin/m-p/463363#M484622 Gysbert_Wassenaar 2013-05-15T17:31:36Z