Simple syntax problem

[Pickering, John (NORBORD)]

My first guess would be that 25.00% is stored as 2500. Try reporting the
value for a few records with a something like picture "^^^^^^^^" output
scale 0 just to see what's really stored in it.

But it's stored as a floating point number so it might not be *exactly*
2500. For floating point numbers (IMNSHO - generally a bad idea in business
systems) 25 might be stored as 24.99999999999999 or 25.000000000000001 (you
fill in the correct number of nines and zeroes :-). Therefore I'd probably
round the floating point number into an integer before doing the comparison.

> -----Original Message-----
> From:	Enid Gentle [SMTP:GentleE@rsc.org]
> Sent:	Tuesday, April 18, 2000 12:24 PM
> To:	powerh-l@lists.swau.edu
> Subject:	Simple syntax problem
> 
> Help!  all you Powerhouse experts:
> 
> This is a query from a trainee sitting here all alone and unable to find
> the
> answer in the manuals.
> Using a basic Quiz report:
> If an element is defined as a float 4, and is defined in the Powerhouse
> dictionary as being a 2-decimal point percentage, complete with % sign,
> how
> do I test it for values?
> I need to extract all items with a value of 25.00%  and I have tried all
> manner of permutations of testing for this value.  Can anyone help me,
> please?  I have run out of initiative and permutations.
> I know it is just a simple syntax thing, but I cannot seem to get it
> right.
> 
> Enid
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.