Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=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.
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)))
Its returning 0
Are you using this in a chart or text box object?
In charts..Bar chart,straight table
Would it be possible to share a sample?