Math Question

[metalteck]

I'm trying to create a calculated field, to get a percent and then query by the result of the percent.

In Crystal 8.5, I wrote this for my formula:
(lpadj/lpchgs)*100

I put this field in my report and then run it. I then use the select expert to query anything less than 5%, but it always gives me a divsion by zero error. I have tried to eliminate any value that may equal 0 in these two fields, but I still get the error. Can someone help.

thank you

 

[Turkbear]

Hi,
You cannot use a computation that has not been done to restrict data from the database...The 2 fields have no values until the data is actually returned from the source..









To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Change your formula to:

if lpchgs <> 0 then
lpadj % lpchgs

Then you could use a GROUP selection formula:

{@yourformula} < 5

-LB