Hello guys.
I need to add the amounts within a MONTH table that meet 3 criteria, within a table:
** CRITERIA **
Type = Expense
Responsible = Office
Payment = Cash
How could I do that?
I have achieved it with two criteria, but when trying for 3 criteria it already marks an error.
Hi @Everardo_Garcia
Please show us what you have tried that doesnโt work. It will give us more if an idea of what you are after thanks,
Snap
I currently use this formula for 2 criteria
SWITCH (
[Month],
โJanuaryโ, SUM (SELECT (January [Amount], [Type] = Income, [Responsible] = Office)),
โFebruaryโ, SUM (SELECT (February [Amount], [Type] = Income, [Responsible] = Office)),
โMarchโ, SUM (SELECT (March [Amount], [Type] = Income, [Responsible] = Office)),
โAprilโ, SUM (SELECT (April [Amount], [Type] = Income, [Responsible] = Office)),
โMayโ, SUM (SELECT (May [Amount], [Type] = Income, [Responsible] = Office)),
โJuneโ, SUM (SELECT (June [Amount], [Type] = Income, [Responsible] = Office)),
โJulioโ, SUM (SELECT (Julio [Amount], [Type] = Income, [Responsible] = Office)),
โAugustโ, SUM (SELECT (August [Amount], [Type] = Income, [Responsible] = Office)),
โSeptemberโ, SUM (SELECT (September [Amount], [Type] = Income, [Responsible] = Office)),
โOctoberโ, SUM (SELECT (October [Amount], [Type] = Income, [Responsible] = Office)),
โNovemberโ, SUM (SELECT (November [Amount], [Type] = Income, [Responsible] = Office)),
โDecemberโ, SUM (SELECT (December [Amount], [Type] = Income, [Responsible] = Office)),
0
)
@Lynn E This is the formula that I use for two criteria within the table for each month.
Now I seek to add one more criterion that of cash payment.
@Steve I already solved it with AND.
SWITCH (
[Month],
โJanuaryโ, SUM (SELECT (January [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โFebruaryโ, SUM (SELECT (February [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โMarchโ, SUM (SELECT (March [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โAprilโ, SUM (SELECT (April [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โMayโ, SUM (SELECT (May [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โJuneโ, SUM (SELECT (June [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โJulioโ, SUM (SELECT (Julio [Amount], AND ([Type] = Expenditure, [Responsible] = Office, [Payment] = Cash))),
โAugustโ, SUM (SELECT (August [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โSeptemberโ, SUM (SELECT (September [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โOctoberโ, SUM (SELECT (October [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โNovemberโ, SUM (SELECT (November [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
โDecemberโ, SUM (SELECT (December [Amount], AND ([Type] = Expense, [Responsible] = Office, [Payment] = Cash))),
0
)
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |