List lookup filtered on the value of a calculated field


I have a form where we have a list lookup and the value of the selected item is used in the formula of a calculated field to retrieve a value from another list. 

I want to use the result of the calculated list in the filter of a second lookup list.

The calculated field uses this as its formula this works OK 

lookup("/sites/payment|Companies","Entity",""+parseLookup(CompanyName)+"","Easy Code")

The filter for the second lookup is in the attached file. EasyCode is the name of the calculated field control.

Any help would be appreciative 


0 Kudos