In the design I want to link AgreementId from AgIDTenRef box to 2ndyrletonlyfee on the RenewalsCompleted box (as shown) but when I do either of these it errors:
CAST(v_statActiveCount_mis.`2ndyrletonlyfee` AS FLOAT) AS TEST
CAST(AgIDTenRef.AgreementId AS VARCHAR) AS TEST
One of the errors is
Error converting data type from varchar to float
2ndyrletonlyfee = VARCHAR
Agreement Id = FLOAT
