I need to convert this value from nvarchar to numeric(38,18). I already tried try_cast but it failed and resulted in NULL. I have also tried CAST and CONVERT but has same result.
try_cast("[Measures].[FID06 Ratio Amount]" as numeric(38,16)) as [Value_Percent],
