Conventional software works just fine for date based analysis if your fiscal year starts on January 1st. Excel will happily let you group dates placed in pivot tables as row or column fields into months, quarters or years. You’ll have nice looking and accurate summary tools in no time – if your fiscal dates match […]

read more from this topic.....

As we’re at the midpoint of the 30 Days to Become a Better Monarch Modeler series, today on day 15 I have a real-life challenge and proposed solution that I think quite nicely reinforces some of the concepts and tools that we’ve discussed so far.
This week a new Monarch Forum member named MikeMetta posted a […]

read more from this topic.....

On day 10 of the 30 Days to Become a Better Monarch Modeler series, we’ll put Monarch’s functions to work to improve our models, both by facilitating finicky data extractions and by adding useful calculations that are based on the extracted data itself.
On day 8, I wrote about the types of calculated fields. In the […]

read more from this topic.....