Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Your first sum must be inside
(Sum (Amount)-Sum(Credit Amount)-sum(%_Qty*ItemsCost))/Sum(Amount)
Your first sum must be inside
(Sum (Amount)-Sum(Credit Amount)-sum(%_Qty*ItemsCost))/Sum(Amount)
and for a field with charactere space, tiy must put it into: [ ] like:
(Sum (Amount)-Sum([Credit Amount])-sum(%_Qty*ItemsCost))/Sum(Amount)