Calculating avg using a string

[former_member998338]

Good Afternoon,

I am trying to calculate an avg of services provided by dividing a count of total values divided by a count of total months.  I am using sql server, and every time I try to  write a formula I get an error message saying a number is required here.  I grouped this report by recorded time and chose a monthly option.

My formula looks like this:

count({IP_FLO_GP_DATA.DISP_NAME})/GroupName ({IP_FLWSHT_MEAS.RECORDED_TIME}, "monthly")

How can make this formula work?

Thanks

[abhilash_kumar · Accepted solution]

Hi David,

Try:

count({IP_FLO_GP_DATA.DISP_NAME}, {IP_FLWSHT_MEAS.RECORDED_TIME}, "monthly")

-Abhilash

[former_member998338 · Accepted solution]

Hi Abhilash,

I have created a formula to get the date difference by month between two starting dates.  I have inserted a count of a measure at the group level, and I want to divide this count by my month formula to get the average I want.  For example- I have a total of 5 for my group that I would like to divide by my month formula-20 months.  My problem is that I can only get the grand total of all measures (31) not my total of 5 from my measure.

My formula looks like

count({IP_FLO_GP_DATA.DISP_NAME})/{@Month }

Do you know how I can make this count look at my Group footer total instead of my report footer total?

Thanks

[abhilash_kumar · Accepted solution]

Yes, you would use:

count({IP_FLO_GP_DATA.DISP_NAME}, {Group_field})/{@Month }

-Abhilash