Expression help with if

[#1]

=sum(if([Expense Month-Year]='Mar-2016' ,

            if([Expense Month-Year]='Apr-2016',

(Aggr((Max([Amount of Expense]) * Pick(Match(pay_frequency, 'Monthly', 'Quarterly', 'Annually', 'Semi Annually','One Time'), 12, 4, 1, 2,1)),%SubspaceKey,[Expense Type],%ExpenseKey))))

but the below expresson with one if is working fine.

=sum(if([Expense Month-Year]='Mar-2016' ,

(Aggr((Max([Amount of Expense]) * Pick(Match(pay_frequency, 'Monthly', 'Quarterly', 'Annually', 'Semi Annually','One Time'), 12, 4, 1, 2,1)),%SubspaceKey,[Expense Type],%ExpenseKey)))

How can I put it for multiple if's.Thank you.

[sunny_talwar]

Sure, try this:

Sum(If(Match([Expense Month-Year], 'Mar-2016', 'Apr-2016'),

Aggr((Max([Amount of Expense]) * Pick(Match(pay_frequency, 'Monthly', 'Quarterly', 'Annually', 'Semi Annually','One Time'), 12, 4, 1, 2,1)),%SubspaceKey,[Expense Type],%ExpenseKey)))

[#3]

Its returning 0

[sunny_talwar]

Are you using this in a chart or text box object?

[#5]

In charts..Bar chart,straight table

[sunny_talwar]

Would it be possible to share a sample?