Data not refreshing when selection changes

Hansie
Participant I

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

0 1 110
1 REPLY 1

Steve
Participant V

You’re using LOOKUP() wrong.

See also:

Top Labels in this Space