Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jenmclean
Contributor III
Contributor III

Calculation for subtracting margin

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!

1 Reply
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


talk is cheap, supply exceeds demand