IF(MAX(COLLECT formula issue
Hi,
There's an issue in one of my sheets and I can't find what the error is, so I'm hoping somebody can help me please.
I have an electric meter submission sheet and a metrics sheet where the data goes into.
I have the below formula, which works perfectly for previous months, but 0 value displayed for the month of February.
- {Value} - Meter Reading column
- {Date} - Created column
- {Meter} - Type column
=IF(MAX(COLLECT({Value}, {Date}, >=$[Month Start]@row, {Date}, <=$[Month End]@row, {Meter}, [Pitchside Meter 1]$1)) = 0, 0, MAX(COLLECT({Value}, {Date}, >=$[Month Start]@row, {Date}, <=$[Month End]@row, {Meter}, [Pitchside Meter 1]$1)))
I typed the formula again and checked the data input on the submission sheet all seems fine.
Please can you see if I missed something?
thanks so much in advance.
Best Answer
-
The issue is February only has 28 days this year and your Month End date is listed as the 29th of February
Answers
-
The issue is February only has 28 days this year and your Month End date is listed as the 29th of February
-
Hi Hollie,
That's it. Thank you very much!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!