Need a dynamic variable

[#1]

I need a vairiable to assign the below scenario

To find out number of reports accessed in a month.... For example: some reports may be accessed for 2 or 3 or 6 months and some many not be accessed for any month.... So variable should be dynamic.

[v_iyyappan]

Hi,

     Cau you attach sample a file.

Iyyappan

[CELAMBARASAN]

Hi,

     Report in the sense Sheets or qvw file?

Celambarasan

[#4]

Attached the sample one.

Two list box will holds the document name and Month end date... It has only limited data. When u select a document name, some month will be selected.

I need a dynamic variable which sould contain the number of months when a doc is selected. I shoul add the variable formula in "Average Visits per User, per Month"

[CELAMBARASAN]

Hi,

     Unfortunately i cann't open your file because i'm using personal edition please can you explain me in text format or in pictorial.

Celambarasan

[#6]

Example to find Unique Users=(Count(Distinct(if(Year([MONTH_END_DT])=Year([MaxDateVar]) and Month([MONTH_END_DT])=Month([MaxDateVar]),[User_Pin_Key],0)))) .......

I need formula to find the  Average Visits per User, per Month=(# of visits / Unique Users actually accessing QV) / (# of months)

im having formula for =(# of visits / Unique Users actually accessing QV i need for (# of months) , where # of months is document accessed in a particular month. I have attached the document name and month date. I need a variable for it.

[#7]

Hi,

You can have variable defined as

vMonths=Month(Max(Month_End_DT))-Month(Min(Month_End_DT))+1

This should give you count of months.