Using A. Heylen Magic List Example, I have made the graph, the Data viewer shows that the correct values are input in the $$ (I tried both the SQL query and a second CF to yield the list). However, the calculation, which is unstored, does not make the value list feeder field show such value. It says unrelated table; which is weird because in the Sample file, the table zipcode is also unrelated to the table settings (which is used to create the magic lists) so I don't get why it is an issue in my case. Where is my error?
Below is the field definition with the script trigger and script parameter definition which is what generates the list. A and B are two variations of the same one is grouped the other isn't