Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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
Partner - Champion III
Partner - Champion III

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