sum agg and Total

[apthansh]

I have the below expression - I want to calculate the Total aggregate by ID...How can I do that.

1.Expression1:

sum(aggr(
if(GetFieldSelections([Type])='Sub',

(If(GetSelectedCount(Currency)>0,
sum([Annual Expense ]/Factors),
sum([Annual Expense ]))*-1),

If(GetSelectedCount(Currency)>0,
sum([Annual Expense ]/Factors),
sum([Annual Expense ]))),[ID]))

2:Expression 2 :

sum(Total(aggr(
if(GetFieldSelections([Type])='Sub',

(If(GetSelectedCount(Currency)>0,
sum([Annual Expense ]/Factors),
sum([Annual Expense ]))*-1),

If(GetSelectedCount(Currency)>0,
sum([Annual Expense ]/Factors),
sum([Annual Expense ])))),[ID]))

The expression is not working.Any help please.

Secons expression 

[Anil_Babu_Samineni]

Is this working for you?

if(GetFieldSelections([Type])='Sub', (If(GetSelectedCount(Currency)>0, sum([Annual Expense ]/Factors), sum([Annual Expense ]))*-1), If(GetSelectedCount(Currency)>0, sum([Annual Expense ]/Factors),
sum([Annual Expense ])))

May be like this?

sum(TOTAL <ID> aggr(if(GetFieldSelections([Type])='Sub', (If(GetSelectedCount(Currency)>0, sum([Annual Expense ]/Factors), sum([Annual Expense ]))*-1), If(GetSelectedCount(Currency)>0, sum([Annual Expense ]/Factors),
sum([Annual Expense ]))),[ID]))