count_groupby

Applications Grid / Reports
#1

Hi, my problem is:
I need to get the monthly revenue in average. I’ve grouped the data by year, and get the total value by using {sum_groupby_revenue}. I wrote the variables in the event “year_OnGroupby” like {sum_groupby_revenue}={sum_groupby_revenue}/{count_groupby}. However, the variable {count_groupby} doesn’t work at all ({count_ger} is ok). The system shows that {count_groupby} is “undefined”, is this a bug or I did something wrong? I know that I can use the average function to get the value. Yet I just want to know why {count_groupby} didn’t work.

LG

#2

{count_groupby} is a field. Have you a field with this name? A variable is $count_groupby or [count_groupby] (public).

#3

No. But according to the macro documentation, i.e. {sum_groupby_xxx} will be calculated automatically, if I activate this field in “Summerize”. I think {count_groupby} should be the same. If I need to define {count_groupby} via SQL-Query, why {count_ger} works?

#4

I have re-read the documentation but no idea … Perhaps {count_group_by} or so …?

#5

Geht auch nicht, denke, dass das ein Bug ist.