sum can't be created, intermittently?

[pelajhia]

I have a percent formula that uses two sum values; it has been working in this report all day and suddenly it seems to no longer be working. The summary fields are working fine,I don't understand why the formula using them would be throwing up an error.
Here's the formula:
if Sum ({@TotalWorkOrders})>0
then
100*(Sum ({@TotalWorkOrders})>Sum ({@TotalWorkOrders}))
else
0

Again, Sum ({@TotalWorkOrders}) displays on the report just fine, as is the Sum ({@TotalWorkOrders}).

Thanks in advance for any advice!

 

[lyanch]

"100*(Sum ({@TotalWorkOrders})>Sum ({@TotalWorkOrders}))"

This makes no sense it essentially reads:

100 * (True/False)

I think the > in this line is your problem.

Lisa

 

[pelajhia]

Shoot. Well, that's really weird, I thought I had just copied and pasted that formula into my question. I went back to my formula and copied it again, here it is (saved despite the error):

if Sum ({@TotalWorkOrders})>0
then
100*(Sum ({@CompletedFlag})/Sum ({@TotalWorkOrders}))
else
0

Not sure why the > symbol was in there, but NOTHING's been right since I quit drinking coffee last week! :\

 

[pelajhia]

I have come up with another way to get the percent figure I need, so I am withdrawing my question. I'm sure I'm doing something too goofy for words, but that's nothing new. Thanks for the help.