month avg

[#1]

Dear Members,

I have follwoing issue

mon  amount

jan     5000

feb     30000

mar    40000

so i Want Avg for every month

ex: jan 31 days so avg is 30000/31 days 999 valuu will come

how its change dynamically by every month selection

[sreenivas]

PFA of the Solution it may help you out.

[#3]

hi

hope this help you

date	amount
1/1/2012	5000

in your expression write

amount / Day(Month(date))

then output display like

date	amount / Day(Month(date))
1/1/12	161.29032258065

thanks.

[brijesh1991]

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

 

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

[brijesh1991]

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

 

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

[brijesh1991]

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

 

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

[brijesh1991]

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

 

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

[brijesh1991]

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

 

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

[brijesh1991]

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

 

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;

[brijesh1991]

Table1:

LOAD Date

(Date#(mon,'MMM'),'MMM') as Mon,amount Inline

[

 

mon,amount

jan,5000

feb,30000

mar,40000
]

;

load

Mon,TextBetween(MonthEnd(Mon),'/','/') as No.ofDays Resident

Table1;