cancel
Showing results for 
Search instead for 
Did you mean: 

Can we create a formula based on group summaries inserted on the report?

Former Member
0 Kudos

Hi,

I am trying to calculate an average as depicted in the picture below -

1) Same Day - Number of visits on a calendar day (I calculated this using Count of @SamDay - inserted a summary)

2) Calendar Date - Distinct count of days between a given date range (I used insert summary again)

3) I need to calculate the average # of visits during the date range i.e. Sum (Same Day)/Distinct count of (Calendar Dates)

FYI. The new calculation should be effective on each value in Group Level 1.(The calendar date is Group Level 2)

As both the base measures are inserted as summaries, I am unable use them in a formula for creating average.

Could anyone please help me in finding a resolution for this?

Regards,

psh

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Parminder,

You can use the Summaries and create a formula to show the average.

Go to the Formula editor and you should see the summaries you've created on the Panel on the top under "Report Fields".

The formula you need to create would be something like this:

Sum({same_day},{group1})/Disctinct Count({Date},{Group2})

Hope this helps!

-Abhilash

Former Member
0 Kudos

Thanks Abhilash, it worked.

~Parminder

Answers (0)