Hi,
I'm getting the following MS SQL error 'Msg 3623, Level 16, State 1, Line 636
An invalid floating point operation occurred.'
I'm running the following update statement (this has previously worked on a different periods dataset):
update #OPF_BUILD
set TOTAL_CAP = LGD * dbo.GET_NORMSDIST((dbo.GET_NORMINVDIST(PD)/SQRT(1 - FINAL_R) )+(SQRT(FINAL_R/(1 - FINAL_R))*dbo.GET_NORMINVDIST(0.999)))
where PD_CHECK not in ('NO_PD')
Can anyone help me navigate this please?