weird issue with chart level formatting calculation,pl need help

[#1]

Hi all,

I would request help from someone to resolve the below issuw.

In the attached file you can see a table with many columns.

considering 3 main columns:

1)current option price

2)option

3)diff= 1-2

I need to get the MTM. = Qty* diff.=0000

but I am not getting my MTM zero due to some format error probably as I am restricting the option values decimal places in chart level.

Please can some one guide me what is wrong here??

sahana

[Anonymous]

sure, I hope that it works with your Environment as well

how do i insert a qvw file (it would be my first time)

[Anonymous]

Hi,

I found it, hope that it works!

[#4]

hi Rudolf ,

thanks for the response

The application is partially working.If you check the one attached,when my "option" changes the 'diff" still shows zero. as shown I changes my calender date from 21st to 18th and my option value changes .but the difference is still showing zero it should have .00# difference.

Please can you have a look and guide me?? I guess its getting rounded off.but i want to show the difference till 3 decimal placed atleast.

sahana

[#5]

hi Rudolf,

I tried round(([Market Price]-"option"),0.001) and it works thanks a lot for your help .

sahana