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