I have a problem in a customer's SQL query, which executes a calculation, but even if I change the value of the fields the return is always the same, I need HUMALLY OF YOUR KNOWLEDGE.
follows code.
In this always returns 1.04
SELECT ROUND (DECODE (a.ie_sexo,'M',((TO_NUMBER('1.112','999.99999999')-(TO_NUMBER('0.00043499','999.99999999')*(TO_NUMBER(TRIM(Aval(b.nr_sequencia,3032)),'999.99999999'))) + (TO_NUMBER('0.00000055','999.99999999') * (TO_NUMBER(TRIM(Aval(b.nr_sequencia,3032)),'999.99999999') * (TO_NUMBER(TRIM(Aval(b.nr_sequencia,3032)),'999.99999999')))) - (TO_NUMBER('0.00028826','999.99999999') * (TO_NUMBER(TRIM(Aval(b.nr_sequencia,2684)),'999.99999999'))))),'F',((TO_NUMBER('1.097','999.99999999')-(TO_NUMBER('0.00046971','999.99999999')*(TO_NUMBER(TRIM(Aval(b.nr_sequencia,3032)),'999.99999999'))) + (TO_NUMBER('0.00000056','999.99999999') * (TO_NUMBER(TRIM(Aval(b.nr_sequencia,3032)),'999.99999999') * (TO_NUMBER(TRIM(Aval(b.nr_sequencia,3032)),'999.99999999')))) - (TO_NUMBER('0.00012828','999.99999999') * (TO_NUMBER(TRIM(Aval(b.nr_sequencia,2684)),'999.99999999'))))),0),2) cp
FROM atendimento_paciente_v a, med_avaliacao_paciente b
WHERE b.nr_atendimento = :nr_atendimento
AND b.nr_atendimento = a.nr_atendimento
AND b.NR_SEQ_TIPO_AVALIACAO = 227
ORDER BY b.nr_sequencia DESC
here always returns 26
SELECT ROUND(DECODE(a.ie_sexo,'M',((TO_NUMBER('4.95','999.99999999')/TO_NUMBER(TRIM(Aval(b.nr_sequencia,3036)),'999.99999999') - TO_NUMBER('4.5','999.99999999')) * 100),'F',((TO_NUMBER('4.95','999.99999999')/TO_NUMBER(TRIM(Aval(b.nr_sequencia,3036)),'999.99999999') - TO_NUMBER('4.5','999.99999999')) * 100),0),1) cp
FROM atendimento_paciente_v a, med_avaliacao_paciente b
WHERE b.nr_atendimento = :nr_atendimento
AND b.nr_atendimento = a.nr_atendimento
AND b.NR_SEQ_TIPO_AVALIACAO = 227
ORDER BY b.nr_sequencia DESC