
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum, If and AND in Expression
Hello future helpers,
I am trying to do a Sum if with two different dimensions criteria. I have looked at other forums and have not found anything that works. Here are two ways I have been trying to make it work:
1.
=(Sum(if(match([Date of report.autoCalendar.Month], 'Month1', 'Month2' and [Edition], '2019'),
([Revenue]))))
This one just doesn't add up to the right values which is really annoying. I have tried adding a second 'MATCH' statement after the 'AND' statement and didn't really do anything.
2. Sum([Date of report.autoCalendar.Month] = {'Month1'}, [Date of report.autoCalendar.Month] = {'Month2'},
[Edition] = {'Editiontype'}, [Revenue])
This formula I found on another forum and I tried to make it work with my data but it isn't. It is saying 'An error in expression: ')' expected. However the number of brackets are even on each side...
It is similar to a SUMifs in Excel, but the forums on SUMifs haven't helped much either. Can anyone help me to where I may be making this mistake. I am writing this expression in a table.
Many thanks,
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=sum({<[Date of report.autoCalendar.Month]={'Month1','Month2'},Edition={'2019'}>} Revenue)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=sum({<[Date of report.autoCalendar.Month]={'Month1','Month2'},Edition={'2019'}>} Revenue)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Many thanks!
