Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to create a line chart on a profit% formula

Status
Not open for further replies.
Dec 18, 2006
69
US
Hi all,

I am currently using Crystal 2008.
I am trying to create a line chart on a profit% formula. The report has 1 group by invoice_date. There are 2 values pulled from the database. They are sales and profit$. I need to calculate profit% per day. So what I did was to summarize my sales and profit$ for group 1 and placed them in group footer 1. I then created a formula @profit%. The formula is below:

IF SUM ({sales}, {invoice_date}, "daily") <> 0
THEN SUM ({profit$}, {invoice_date}, "daily") /
SUM ({sales}, {invoice_date}, "daily") * 100
ELSE 0

I then placed the formula at the group footer 1. Everything works well. However, I can't seem to figure out how to chart that @profit%. When I tried using chart expert, the chart didn't reflect the values in that formula.

Any advice is greatly appreciated. Thank you.

TTL101
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top