Same expression of a virtual column not giving results in more than one table

Hi
I have a table “Purchase” that includes purchases of different SKU
In another Table A, I’ve created a virtual column “Related Purchases” to list all purchases of specific SKUs using expression REF_ROWS(“Purchase”, “SKU”) and also created another virtual column “Purchased Qty” using expression Sum([Related Purchases][Quantity])
This is giving an appropriate result as expected.

However, when I’m using exact same logic and expression in another Table B, it is not giving any result. I tried creating another Table C but the same issue of no results.

Request if anyone can help.

Solved Solved
0 4 293
1 ACCEPTED SOLUTION

Thanks @Kirk_Masden!
I could figure out the key related issue.

View solution in original post

4 REPLIES 4
Top Labels in this Space