Time Periods Calculation

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Solved3.22K viewsFormulas and Functions

I have created a TimePeriods matrix where I have entered additional (meta) items for future model use.

In a separate matrix, I want to enter a data representing the last period actuals have been entered.

In the TimePeriods matrix, I want my Date item to self-populate with a 1 or a 0. (1 = actual data is populated in the model, 0 = no actual data in the model).

As a new user, 1) I’m probably making this too hard, and 2) there are probably other ways to better address my requirement.

For now, I’d just like to nail down the structure of the model of the above. I’ve also included a spreadsheet which shows an example.

If I cannot add 2 attachments to a question, I’ll add my Quantrix model in this post. I’ll add the xls file in the second post.

Sorry if this is too easy of a question (warning: I’ll have more).


Selected answer as best

Hi mark,

QM allows a more compact solution. To solve your problem try this model.

Selected answer as best
You are viewing 1 out of 6 answers, click here to view all answers.