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

[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;

[#5]

Hi,

Please see the attached file,

it helps U.

Below expression fullfill ur requirement

Amount1/Day(MonthEnd(MakeDate(2013,WildMatch(Month1,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')))) as MonthAvg

Regards

Kabilan K.