Cross tab, formula calculation

[dtrumbower]

I hope this is easy, I just can't figure it out yet.

I have a cross tab that lists all products and the the total quantiies. I want to have a third column that takes the total qty for each product and divide it by bundle size. The bundle size is a field from the stored proc.

I'm using 8.5.

Thanks
Dwight

 

[kenhamady]

You can't do this in any version of CR, since you can't create a cross-tab cell. However, since you have 2 fixed columns you don't really need a cross-tab. Create a manual cross-tab with conditional totals as described in faq767-995, and then you can use your subtotals in your formula.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com