topic Re: Formula...!!!! in Application Development and Automation Discussions

Formula...!!!!

Former Member — Sat, 26 Jul 2008 09:46:20 GMT

GS_FINAL-OR2 = ( ( ( LIS_TY_QALS_QAPP-OR2 * GS_FINAL-TON ) + ( GS_ONE-OR2 * GS_ONE-C_TON ) ) / V_DIVIDE ).

GS_FINAL-OR9 = ( ( GS_FINAL-OR8 * 100 ) / ( ( 2.8 * GS_FINAL-OR5 )+ ( 1.2 * GS_FINAL-OR6 ) + ( 0.65 * GS_FINAL-OR7 ) ) ).

The 1st formula is working fine but 2nd one is not working fine

comment what is the mistake in 2nd one

Former Member — Sat, 26 Jul 2008 09:48:46 GMT

hi check this...multiplication with the decimal number

*0.65 * GS_FINAL-OR7*

Former Member — Sat, 26 Jul 2008 09:51:48 GMT

MEANS WE CANT MULTIPLY ANY NUMBER BY DECIMAL NUMBER, I THINK WE CAN , WHAT DO WANA SAY BE CLEAR

Former Member — Sat, 26 Jul 2008 09:55:42 GMT

Hi,

In dynamic formula calculation, it is better to have like this;

0.65 * GS_FINAL-OR7 = ( ( 1 / 1.5) * (GS_FINAL-OR7))

the same way try to change the following it should work;

2.8 * GS_FINAL-OR5

1.2 * GS_FINAL-OR6

2.8 * GS_FINAL-OR5

you have few good example if your working in IS-OIL!!!

If the hint is usefulu2026 Say thanks by rewardu2026.

Regards,

Prabhu Rajesh

Edited by: PrabhuRajesh Janardanan on Jul 26, 2008 11:56 AM