Current User Lookup
I would like to allow users to determine a target currency to use in translating values and enable that selection to be unique to them.
First thoughts are that I can create a selection module dimensioned by user containing a line item formatted as the currency type.
My challenge is to then direct a formula into this selection so that I can feed downstream modules with the correct selection unique to that user.
Is there a LOOKUP or SELECT function I can use which will enable me to link the target module to the source and direct the formula to to take the correct selection for that user?