Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Percentage calculation in expression of report
Message
 
 
To
30/11/2001 16:13:40
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00588031
Message ID:
00588257
Views:
46
You're right I need to check and see what each field comes out to and then I'll try and calculate it step by step.
Thanks again!
Max


> Max --

> >Hi Jay,
> >I didn't find any SET FILTER TO statements after the table is opened and there is an index in ascending order by employee name but no FOR clause. I calculated the values by hand by looking at the results of the rows, adding them individually and then getting the percentage.

> I don't mean to beat a dead horse, but did you plug those values into the formula you have in the report? If so, then pardon me for belaboring the issue. But, I suspect you'll find that plugging those values by hand into the report formula will give different results than doing it by hand. I don't think that the formula belongs both above and below for an percentage calculation.

> >One thing though, there are zero values in some rows and I just omit them while doing my algebraic calculation so could it cause the expression to evaluate to 0 because of the additional 0 values? I have the variables set in numeric format.

> That shouldn't impact doing a sum.

> Jay
Previous
Reply
Map
View

Click here to load this message in the networking platform