分析水晶报告的公式

问题描述:

Hello All,



我正在创建一个水晶报告,其中包含一个按日期分组的图表,然后汇总与该日期对应的所有数据。由于我是新手,我需要帮助。



我有一张表有日期和相应的一些actual_rev,hrs_available等。



我需要一个公式,我得到 按每个日期分组的hrs_available的actual_rev / sum的总和 。我需要在每个日期的图表栏中显示。



非常感谢您的回复。它有点紧急。



提前谢谢。

Hello All,

I am creating a crystal report which consist of a graph which has a group by date then summarize all data corresponding to that date. As I am new to this i need help on this.

I have a table which have dates and corresponding some actual_rev, hrs_available, etc.

I need a formula where I get the sum of the actual_rev / sum of the hrs_available grouped by each date. This I need to show in the graph bar of each date.

Your responses are very much appreciated. Its a bit urgent.

Thanks in advance.

这里我在公式中使用了这个但是这不是给出了期望的结果集。



Here I have used this in formula but this is not giving a desired resultset.

({daily_summary_fact.actual_revenue},{daily_summary_fact.date})/({daily_summary_fact.hrs_available},{daily_summary_fact.date})





谢谢。



Thanks.