Calculatged field of a nested field in linked lookup
I have the following situation
Calculated field --> Lookup table --> field (lookup table) --> field
Calculated field --> Customer Hierarchy --> Branch --> Code
and if you look on the calculated expression is:
"Customer Hierarchy [Branch] & 4 digits generated sequentially"
the problem is that branch is a lookup and i don't want to get the default field but a other field from this lookup.
if it was java it was something like this
"Customer Hierarchy [Branch].Code & 4 digits generated sequentially"
Were "Code" is a field inside Branch
What is the solution?