TryingToLearn101
MIS
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
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