calculate running total field?

[mapperkids]

Hi,

I'm using the CR v 11 and I did a 3D bar chart that showing two series of data for each salesman , one is their outstanding orders and the other one is the closed orders.

Both bars are get the value from two running totals that I defined in the report by a distrinct count on salesman name.


For example for salesman_A , the bars are showing like

15 outstanding orders
70 closed orders

Now I want to show the percentage for the outstanding and closed orders. How can I do it?


Based on the example above.

The calculation is 15 / (15 +70) * 100 = 17.64%

Any suggetion? ideally can put that percentage on the report somewhere or as another data series on x aixes.

Thank you!

[bananamy]

I think I understand your question,

I would create a formula 'f_percent' -(under formula fields in the field explorer)

then define it as.....

({TABLE_NAME.OUTSTANDING_ORDERS}/({TABLE_NAME.OUTSTANDING_ORDERS}+{TABLE_NAME.CLOSED_ORDERS})*100)

[mapperkids]

I think I understand your question,

I would create a formula 'f_percent' -(under formula fields in the field explorer)

then define it as.....

({TABLE_NAME.OUTSTANDING_ORDERS}/({TABLE_NAME.OUTSTANDING_ORDERS}+{TABLE_NAME.CLOSED_ORDERS})*100)

Thank you for your reply, but the problem is those two values (# of outstanding, closed orders) are not part of the table fileds, it is two running total that I defined and calculate at runtime.

But now I need to get the value of those two running totals in order to calcuate the percentage between the outstanding/closed orders.


Any idea?