Why Don’t Recurrence Words Work?

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved2.47K viewsFormulas and Functions
0

I have attached two screen shots from a model I am trying to create. The problem I have is using Recurrence Words (PREV and THIS for example).

The Matrix data was created via DataLink from a two dimensional matrix. This was created by importing data from Excel.

The Matrix model was delinked but the Year category may not have been. I enabled the time series on this category.

My question is why do RECURRENCE WORDS not seem to work with the setup I have when I compare this to the setup that Quantrix used in its sample model for integrated financial statements.

The error message in the screen shot of my model says that the names for the cells can only be used with categories and groups. As you can see the name CASH, Beginning Balance is part of the category CF Accounts. In the formula it puts this name in quotes. When I look at the sample model provided by Quantrix for integrated financial statements I don’t see any difference between the setup of that model and my model as noted on the screen shots attached.

The RECURRENCE WORDS work for their model but not mine yet I don’t see any difference with the way the items are setup under theirs and my model.

I am using Qv 5.3.7 on Mac in case this matters.

Any help is greatly appreciated. Thanks.

Changed status to publish
0

Oops, Year[THIS] was skipped in the left-hand sides of the formulas.
So, provided that your model has the Year category, formula 1 will be:

  • ‘CASH, Beginning Balance’:Year[THIS] = ‘CASH, Ending Balance’:Year [PREV] + Change in cash

Or it will be, if the items will be renamed:

  • CASH Beginning BalanceYear[THIS] = CASH Ending Balance:Year [PREV] + Change in cash
Edited answer
0

Hi,

1. If the names of items, groups or categories have any punctuation, parentheses, arithmetic operations symbols, then in the QM formula editor these names will be enclosed in apostrophes (quote marks). Try renaming "CASH, Beginning Balance" in "CASH Beginning Balance" (the comma is removed) – the apostrophes in the name will disappear from the formula.

2. An item recurrence of one category can be strictly either along all items of ANOTHER category or along a group of items of ANOTHER category. In the model from Quantrix the recurrence Free Cash Flow item is along all items of the Year category. If necessary, it would be possible to set the recurrence of Free Cash Flow only along the Forecast group, for example. In this case the formula number 4 would look like this:

Starting Cash Balance:Forecast [THIS] = Ending Cash Balance:Forecast [~PREV] + Ending Cash Balance:’2014′

Provided that your model has the Year category, formula 1 will be:
‘CASH, Beginning Balance’ = ‘CASH, Ending Balance’:Year [PREV] + Change in cash

Or it will be, if the items will be renamed:
CASH Beginning Balance = CASH Ending Balance:Year [PREV] + Change in cash

Latest Questions