Are custom formulas allowed in the “formula” parameter? I receive errors when I use custom formulas and P123 pre-defined vars such as Pr2BookQ.
Could you extend the counter (CTR) to allow more than 10 years? Wouldn’t it make sense to allow use from database inception to current year? I can’t imagine the computational demands are anything but light.
Custom formulas are not allowed. Using Pr2BookQ should not be a problem but that’s just a single data point, so it’s not useful in the Loop functions. You still need CTR in “formula”.
What 10 years are you talking abut ? If you are talking about financial statements we can only reference 11 past annuals and 25 quarters from any point-in-time. Example, with an as-of date of 2005 you can only access annuals back to 1994 even if the company has more.