Got it to work. thank you guys for all your help.

Ok. Thank you you've been a great help.

=CDBL(MID(Fields!PRE_LAB_VAL.Value,INSTR(Fields!PRE_LAB_VAL.Value,"=")+1,INSTRREV(Fields!PRE_LAB_VAL.Value,"=") - (INSTR(Fields!PRE_LAB_VAL.Value,"=")+1 )))

This almost worked.

the data is not consistent in the report.

for this it works

PLT=48=etc...........................I get 48

PLT-241=etc..........................I get 241

but

PT=45.7=etc.........................I get #error

PT=17.9=etc.........................I get #error

I hope this make sense....

I put this but still getting an error:

CDBL(MID(Fields!PRE_LAB_VAL.Value,INSTR(Fields!PRE_LAB_VAL.Value,"=")+1,INSTRREV(Fields!PRE_LAB_VAL.Value,"=") - INSTR(Fields!PRE_LAB_VAL.Value,"=")+1))

Thank you.

I am sorry I am new and this is not clear to me.

I added a column and inserted the formula. Your looks like 3 columns. FirstDelim, seconddelim and...

=CDBL(MID(Fields!PRE_LAB_VAL.Value,INSTR(Fields!PRE_LAB_VAL.Value,"=")+1,INSTRREV(Fields!PRE_LAB_VAL.Value,"=") - INSTR(Fields!PRE_LAB_VAL.Value,"=")+1))

I use it but getting an error

Hi All,

I used this one which almost worked.

=Mid(Fields!PST_LAB_VAL.Value, InStr(Fields!PST_LAB_VAL.Value,"=")+1, InStr(Fields!PST_LAB_VAL.Value, "=") - 1)

Pre Lab Val------------------------ Post Lab Val -------------------a ...

I'll give it a try. thank you guys for the quick reply