How to calculate Sum of total

[#1]

I want to calculate sum of total for following expression

(Sum (if(([Ledger Account]>=41112 AND [Ledger Account]<=41118) AND [Cost Centre]<201,

(if([Debit/Credit]=2,[Amount in EUR]*(-1),[Amount in EUR]))))

i tried

(Sum Total (if(([Ledger Account]>=41112 AND [Ledger Account]<=41118) AND [Cost Centre]<201,

(if([Debit/Credit]=2,[Amount in EUR]*(-1),[Amount in EUR])))) but its not working

Please help on this?

[jjordaan]

Hi Rahul,

If I understand your question correctly in a chart you can use within the expression the setting sum of rows.

Or you can use the Aggr function to do it.

If I didn't understood your question let me know

[#3]

Hi Jeroen,

I want to calculate calculation highlighted in Red

791.246/(3.77+2.133)

In the last column i.e A expression i have written

=sum(

if(([Ledger Account]>=41112 AND [Ledger Account]<=41118) AND ([Cost Centre]<201),

(if([Debit/Credit]=2,[Amount in EUR]*(-1),[Amount in EUR]))))

/

(Sum ( aggr( if(([Ledger Account]>=41112 AND [Ledger Account]<=41118) AND [Cost Centre]<201,

(if([Debit/Credit]=2,[Amount in EUR]*(-1),[Amount in EUR]))),[Cost Centre],Costcentre))

+

Sum (if(([Ledger Account]=41111) or ([Ledger Account]>=41119 and [Ledger Account]<= 41130)

and ([Cost Centre]>=201),

(if([Debit/Credit]=2,[Amount in EUR]*(-1),[Amount in EUR])))))

For referance i have attached QVW file to main post pls help me on this.

[jjordaan]

See attached file