This content has been marked as final.
Show 2 replies

How do I calculate Margin in Qlikview
emaC Feb 25, 2011 10:21 AM (in response to Mark Staffiere)Your first sum must be inside
(Sum (Amount)Sum(Credit Amount)sum(%_Qty*ItemsCost))/Sum(Amount)

How do I calculate Margin in Qlikview
emaC Feb 25, 2011 10:23 AM (in response to emaC )and for a field with charactere space, tiy must put it into: [ ] like:
(Sum (Amount)Sum([Credit Amount])sum(%_Qty*ItemsCost))/Sum(Amount)
