Focal Point
result of division

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2701044132

June 07, 2007, 06:35 AM
roby
result of division
I have this problem:
P8.2L = Field1 / field2;
At time I have as result ‘*************’
Is possible to check if the result is ‘****’?
In the output I must :
If result = ‘********’ then 99999999
Else the risult of division
thanks for any help and excuse-me for my english
June 07, 2007, 07:07 AM
FrankDutch
Roby

What do you think will cause the '****'

How about trying to enlarge the formula field to lets say RESULT/P15.2L and see what happens...




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

June 07, 2007, 07:35 AM
roby
If I define Result/p15.2, I have the correct result.
The cause of '*****' is that the field RESULT is more little then result of division.

In my pgm I do:
result1/p15.2 = Field1 / field2
result /p8.2 = if result1 gt 99999,99 then 99999,99 else result1 ;

Is possible to ckeck with a few function if the result is '****'?
I must to inform when the result of operazion is out of range (is the filed is out of range I must to write the field of output 99999,99).

excuse-me for my english
June 07, 2007, 08:33 AM
Alan B
Roby

The *s' are an output format only, so you cannot test for them.

but you have the code basics correct for testing.

result/P8.2 = 99999999,99;
newResult/P8.2 = IF result GT 99999,99 THEN 99999,99 ELSE result ;


Alan.
WF 7.705/8.007
June 07, 2007, 08:43 AM
roby
Thank you very much !!!

Smiler