How do I calculate Margin in Qlikview

[#1]

Hi,

I have just started using Qlikview v9.0 and i'm trying to calculate Margin in a straight chart but can't get it to work, can someone help tell me what I'm doing wrong?

The Calculation is: Sum ((Amount)-Sum(Credit Amount)-sum(%_Qty*ItemsCost))/Sum(Amount)

Thanks

[#2 · Accepted solution]

Your first sum must be inside

(Sum (Amount)-Sum(Credit Amount)-sum(%_Qty*ItemsCost))/Sum(Amount)

[#3]

and for a field with charactere space, tiy must put it into: [ ] like:

(Sum (Amount)-Sum([Credit Amount])-sum(%_Qty*ItemsCost))/Sum(Amount)