Sage 100

I created a cross-tab crystal report displaying monthly sales with a total. Now the customer wants me to add columns for avg cost, Total inventory value, and QOH. With my limited knowledge I want to tell him I need to create a whole new different report. Am I wrong?

You could get the avg cost, probably, but I don't think the Total Invt or QOH would be possible.

But I don't think I can just make a column and keep everything on one line Or can I?

No. I don't think the Total Invt or QOH would be possible. Unless maybe if they only have one warehouse and you used the MAX command instead of SUM.... but probably not.

Thanks Beth

Just thinking out loud; if you add the QOH and Inv Value to each line of the data set you are reporting on, then the average of each would be the base value. You could also pull the MIN or MAX of the values and come to the same result.