How to count the number of times a month shows up minus 1?
Hi, I'm trying to create a logic into the line item "End". My goal is to count the number of times a specific month appears without including the first occurrence. If November appears 4 times, I would like the "end" line item to display 3. Similarly, if December appears 5 times, I want "end" to show as 4.
I want to use the END line item for my "MAX expense" calculation.
- module is dimensioned by weeks
Any ideas? thanks!