Using ‘[THIS + Variable]’

Solved9.32K viewsFormulas and Functions
0

Hi all,

Not sure if I am missing something obvious here but i would like to use a recurrence formula where the ‘offset’ is determined by a variable,

eg an accounts receivables example, I am looking at difference between revenue recognition and cashflow in, so if you get cashflow in the same month as revenue in formula would be

Cashflow:Month[THIS] = Revenue:Month[THIS]

If it was 1 month behind it would be

Cashflow:Month[THIS] = Revenue:Month[THIS – 1]

etc. i would like to be able to make the offset (like the -1 above) a variable, so formula would be

Cashflow:Month[THIS] = Revenue:Month[THIS – [i:201o69c5]referencevariable[/i:201o69c5]]

where referencevariable is an input item on another matrix.

When I input the formula like the above I get an error (see attached example). Is my syntax wrong? If this isn’t a natural capability of Quantrix has anyone figured out how to do this?

Thanks

Attachments

Example.model
0

The indirect function will work for this purpose, but could potentially slow down some calculations. We recognize this as concern, and will be implementing a new function in the next Quantrix Modeler release (mid-2013) that will address this scenario more efficiently.

You are viewing 1 out of 10 answers, click here to view all answers.

Latest Questions