Margin calculation in listbox

[fatihtomruk]

Hi,

I want to calculate margin in listbox. I mean, on below listbox, first red line's value(Brüt Kar Marjı %) must be BRÜT KAR / Satış Gelirleri (175.421/1.131.781) .

Likewise, second red line's value must be 'FAALİYET KARI / Satış Gelirleri' (58.237 / 1.131.781)

Likewise, last red line's value (EBITDA KarMarjı %) must be 'EBITDA(FAVÖK) / Satış Gelirleri'(194.952 / 1.131.781)

'B' is an expression that sum(Budget)

Could you please help me.

Thank you.

Fatih Tomruk.

[tresesco]

This should ideally be done in the script. Check this blogs : How IntervalMatch Solved My Profit and Loss Dilemmaand How to Create a Profit and Loss Statement in QlikView

[fatihtomruk]

Thank Tresesco. But This can't solve my problem.

I need a formula like this;

if(=2,sum({<B={'2'}>} C) / sum({<B={'3'}>} C) , sum(C))

But it doesn't work now. Can anyone help?

[tresesco]

But This can't solve my problem.

I could not really understand why this can't.. (not sure if missing something). Check a small sample how you can probably proceed.

[Anil_Babu_Samineni]

Screen shot is not useful for helpers. Would you share excel

[fatihtomruk]

My values is not 1, 2, 3 and 4 but 'Brüt Kar' , 'Satış Gelirleri'.

And the other, first margin must be Brut Kar / Satış Gelirleri but second must be 'Faaliyet Karı / Satış Gelirleri'