Hi all
I have a column to capture MEMNAME which is a REF from table USERS.
I have another virtual column (WALLET) to display a value based on the selection from table USERS.
I have the following formula in WALLET :
LOOKUP([MEMNAME],“USERS”,“MEMNAME”, “MEMWALLET”)
The issue I have, is when the value of MEMNAME changes, the value of WALLET does not.
Any guidance would be appreciated.
Thank you
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |