Taking an average 1

[pk400i]

HI I have a union SQL that join the History and current tables. This works fine except there is one issue that have to be accounted for. I would like to account for this in the SQL rather than the reporting level. The first issue may be handled by changing the SQL to left joins.

1. Averages are made if items are purchased multiple times at differing prices.

Can this be handled as a formula?

 

[lbass]

You haven't really explained what you are trying to do. We don't know if what you are saying is a problem or a goal. You should explain the results you are getting and show samples, and then explain/show examples of the results you would like to see instead.

-LB

 

[pk400i]

For now, it's been solved I don't need to do this in Crystal.