Hi,
I am trying to run a simple query where I divide values by 1. Many of the results are correct but often they are wrong.
This is the query:
And here is an extract of the results:
As an example, look at the second row of BSPR. 1/BSP should give 0.0675... but it doesn't. It's the same with the penultimate row in BSPR and elsewhere.
Can anyone suggest what the issue might be?
Thanks
I am trying to run a simple query where I divide values by 1. Many of the results are correct but often they are wrong.
This is the query:
And here is an extract of the results:
EVENT_ID | SELECTION_NAME | BSP | BSPR | PPWAP | PPWAPR | MORNINGWAP | MornWAPR |
---|---|---|---|---|---|---|---|
116821865 | Investissement | 2 | 0.5 | 2.04211327886025 | 0.489688799515629 | 2.36734735680065 | 0.422413718513809 |
116821865 | Bennelong | 14.796570571897 | 6.75832278257296E-02 | 12.6466123626234 | 0.079072558826541 | 9.60161536643841 | 0.104149141767896 |
116821865 | Prime Exhibit | 9 | 0.111111111111111 | 8.32956245936419 | 0.120054325167559 | 6.43245421804421 | 0.155461658350372 |
116821865 | Mister Green | 32 | 0.03125 | 31.3575591097099 | 3.18902372630894E-02 | 11.2505352142602 | 8.88846602366511E-02 |
116821865 | Elusive Ellen | 10 | 0.1 | 9.34990225756201 | 0.106952989716146 | 9.03321846703053 | 0.110702514685082 |
116821865 | Sutton Sid | 44 | 2.27272727272727E-02 | 44.1101434795782 | 2.26705224947403E-02 | 30.7259364397246 | 3.25457940708076E-02 |
116821865 | Its Only Business | 5.785896489 | 0.172834063295321 | 6.68945998601978 | 0.149488897772001 | 10.4175027472858 | 9.59922952994225E-02 |
As an example, look at the second row of BSPR. 1/BSP should give 0.0675... but it doesn't. It's the same with the penultimate row in BSPR and elsewhere.
Can anyone suggest what the issue might be?
Thanks