1 Reply Latest reply: May 15, 2013 1:31 PM by Gysbert Wassenaar RSS

    Calculation for subtracting margin

    Jennie Elliott

      I have the following expression:

       

      (Sum({1<LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'TirePower'}, Locations.CorporateOfficeFlag={0},Locations.TirePowerID-={1,9}, TPCustomerInvoicesDetails.TransactionDetails.DET_TransTypeID={1, 17} >}[Gross Revenue])

      +

      Sum({1<LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'MaddenCo'}, IncludeInUnitsSoldProdClassFlag={1},IncludeInUnitsSoldPrdClass47Flag={1}, MaddenCoCustomerClass-={5,9},IncludeInUnitsSoldProdClassFlag={1},Locations.TirePowerID-={1,9} >}[Gross Revenue]))

      /4

       

      Sum of Gross Revenue from 2 different sources, dividing by 4...

       

      I need to subtract 35% margin

       

      Does anyone have any suggestions on how to properly write this expression?

       

      Thanks in advance!

        • Re: Calculation for subtracting margin
          Gysbert Wassenaar

          Subtract 35% of the result of the expression? So that 65% remains?

           

          0.65*(Sum({1<LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'TirePower'}, Locations.CorporateOfficeFlag={0},Locations.TirePowerID-={1,9}, TPCustomerInvoicesDetails.TransactionDetails.DET_TransTypeID={1, 17} >}[Gross Revenue])

          +

          Sum({1<LastYearPayPeriod={1}, InvoiceDetails.SourceSystem={'MaddenCo'}, IncludeInUnitsSoldProdClassFlag={1},IncludeInUnitsSoldPrdClass47Flag={1}, MaddenCoCustomerClass-={5,9},IncludeInUnitsSoldProdClassFlag={1},Locations.TirePowerID-={1,9} >}[Gross Revenue]))

          /4