From last 2 Days i m trying to use Lookup in calculate Value, But its not woking.
Below it the command i used by no result.
1st way : lookup("UserDepartment","CostCenter",UserDepartment,"cost")
2nd Way: lookup('UserDepartment','CostCenter',parseLookup(UserDepartment),'cost')
List Name: UserDepartment
Colum Name: CostCenter
Control Name: UserDepartment
Store Outcome: Cost
IT shows loading and then, No value displayed.