Error in the cast statement

[Ashok Kumar Manoharan]

For the below code I am getting the error " Msg 8114, Level 16, State 5, Line 1 Error converting data type nvarchar to float" can someone help me in getting the below fixed.

Thanks!.


Select A.FISCAL_YEAR,
A.FISCAL_QUARTER,
A.REG as REGION,
A.DISTRIBUTOR,
Cast(sum(A.sales-A.discount)/1000000 as float) as sale,
Cast(sum(A.Sales_t-A.discount_t)/1000000 as float) as sales_t
from dbo.EG_WW_INDIRECT_DATA A
where a.FISCAL_YEAR in ('FY14','FY15','FY16')
group by A.FISCAL_YEAR,
A.FISCAL_QUARTER,
A.REG,
A.DISTRIBUTOR