Val Function Does not Work

[DBFIN]

I used a simple Val() function to convert $50,000 from text to number, but it returns a value of zero. The script is a follows:

BI_DED_AMT: Val(IIf([Factor PL_Deductible]="None","0",[Factor PL_Deductible]))

 

[CJ_London]

you need to lose the $ sign

e.g. .........,mid([Factor PL_Deductible],2)))

 

[DBFIN]

Thank you, that works.