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! Go to Solution.
Thanks @Kirk_Masden!
I could figure out the key related issue.
User | Count |
---|---|
28 | |
14 | |
3 | |
3 | |
3 |