General information
Category:
Reports & Report designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only