﻿alter function fGetMojoodiKala(@Fc_ID as integer =0, @Pro_ID_VahedMali as integer, @Kal_ID int , @Anb_ID int, @EndDate as integer=0) returns float as
begin
	return isnull(
		(select sum(isnull(f.varede,0.0)) - sum(isnull(f.sadere,0.0))
		 from dbo.fGetKalaVaredeSadere(@Fc_ID,@Pro_ID_VahedMali,@EndDate) f 
		 where f.Kal_ID = @Kal_ID and(@Anb_ID = 0 or @Anb_ID = f.Pro_ID_Anbar))
		,0.0);
end
