I’m wondering if there is any way to set the range to be skiped over (when using the Skip operation) dynamically? I was hoping I might be able to set the range with Indirect – ie:
Well Name = Exp Well Summary::Well Name Skip Indirect(“ExpWellID[“&Counta(Exp Well Summary::Well Name)&”] .. ExpWellID[LAST]”)
But I get a syntax error when trying to use Indirect with Skip. Is there any other way to do this?
Hi – You could like the Year category to a new matrix, then set a flag to indicate when the calculations should occur for Loan and Depreciation.
Then you can use this flag in an IF or SWITCH function, and avoid having to use a SKIP.
You can then simply change the flags to adjust the calculation.
Please see attached.