Is it possible to provide a sample workbook?
HI - thanks for the reply.
The workbook this comes from is 25MB in size, and full of confidential information.
I was hoping I had surfaced enough info above to enable a response.
If it results in zero it means that the result of your formula is False. It is tough diagnosing the internal working of a workbook without seeing an anonymized version. You don't need to share anything sensitive, a small size dummy data will do. Otherwise, every response here will be speculation.
My general advice will be to look at your formula again. If a formula is not returning the expected result, the best way to troubleshoot it will be breaking it down to its constituent parts.
So I will create a few individual formulas and place them side by side in a table to see what the problem is.
Create these separate calculate fields;
6. ATTR(YEAR([Date])) = Year(NOW())
7. ATTR([Date]) <= [MaxDate]
8. ATTR(YEAR([Date])) = Year(NOW()) AND ATTR([Date]) <= [MaxDate]
Put these 8 fields in a table side by side and compare their results. You will immediately see what is causing the expression to return False and consequently zero. Since you've exceeded the default 6 display columns, remember to go to Analysis - Table Layout - Advanced. Change Max row and column labels to 16.
Hope this helps.
That's a really helpful suggestion, Ossai. Thank you.
I will try this tomorrow and let you know what comes out.