Formula not showing up in Chart Expert

[GCL2007]

Using Crystal Reports XI, am trying to create a bar chart using the below formula as one of the fields, but I cannot see it to select it in Chart Expert. Can I not use a Running Total field?

if {#DIVqtyShip}=0 then 0 else
1000000*(Sum ({@rma qty}, {@Division}))/(({#DIVqtyShip}))

Any thoughts?

 

[lbass]

Something that complex won't work for charting unless you go a very complex route. First I would check to see whether you really need the running total. Please explain the exact setup of the rt. Also show the content of both formulas and of any formulas nested within them.

-LB

 

[GCL2007]

Thanks LB... Let me rethink the structure of the report. Will re-post if I don't get anywhere....

 

[lbass]

If you can replace the rts, you will be in better shape for charting.

-LB