Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ID | TYPE | AMOUNT | ||||
1 | RENT | 400 | ||||
1 | RENT | 200 | ||||
1 | DEP | 300 | ||||
1 | DEP | 300 | ||||
2 | TAX | 100 | ||||
2 | TAX | 200 | ||||
2 | RENT | 400 | ||||
2 | RENT | 100 | ||||
For each ID I have to get the max of amount of each type and then sum it.. | ||||||
Here Ex: ID =1 ,Max(Rent) =400 | ||||||
Max(Dep)= 300 | ||||||
For ID =1,Amount is 700 |
Thank you very much .
May be this:
Sum(
If([Expense Month-Year] >= date(Today(),'MMM-YYYY'),
If([Expense Month-Year] <= date(AddMonths(Today(),12),'MMM-YYYY'),
Aggr(
(Max([Amount of Expense]) * Pick(Match(pay_frequency, 'MONTHLY', 'QUARTERLY', 'ANNUALLY', 'SEMI-ANNUALLY'), 12, 4, 1, 2)),%SubspaceKey,[Expense Type]))))
Thank you very much...it made wonders