I have a matrix object containing image display objects and several Text Editor Objects which looks like this:
Two of the text editor objects display related data, using a formula like this:
I noticed than whenever I use a related() function in a matrix, that object needs to be the front most object, otherwise, any other object using formulas to display values is not updated in the matrix.
Of course, the real problem is when I have two or more TEOs with related() functions, as only one of the can be the front most. The screenshot above incorrectly displays the same quantity for all the lines.
Grouping them to make them both the front most didn’t work. It seems that the matrix can’t display grouped objects. Is this a known bug? I couldn’t find any reference to this problem.
My workaround is to use lookup() instead of related().