When using 2 or more aggregate functions in a screen and for a date in the past more than ~1 or 2 weeks ago → display NA for some of the original factors.
This is not only a display bug as it seems to also create issues for my calculations in a more complex screen.
I can share the more complex screen later but if you can first have a look at this, it might fix all the problems in one go.
No - this is not it in this case. There are only 40 stocks displayed on the screen courtesy of the last row “RBICS(leisure)”
→ And it would be the same problem whether I have 2 rows of aggregate calculations or one
→ and it would not work either when I use today’s date (shift the date to today and everything works fine)
Jerome, it’s a different restriction. Historically there’s a limit with rows & # of columns. After a certain number of columns all values are NA. Try re-ordering the rules and you will see a different column become NA.
To be safe, can you confirm that this is just a display thing i.e. the values that I store in @variable are correctly retrieved, stored and used?
In other words, when I use Showvar(@x, some function using P123 data)…
→ the column of P123 data might display N/A
→ but the variable @x would have stored and used the correct value.