Need year start

[bharatkishore]

Hi All,

I am having a field called month and in that the data like Jan-15,Feb-15.....May-16.

Now first thing i needed is I need to get Jan-16..If  i select May-16 i am getting as Jan-16 by writing the following expression

YearStart(S5_Month2) and for monthend i have given like this MonthEnd(S5_Month2)..

Now i need to write an expression like sum(if(S5_Month2>='1/1/2016', if(S5_Month2<='5/1/2016',([S5_Leads])))) without hard coding..

Kindly suggest

Thanks,

Bharat

[bharatkishore]

I have given the following hard coding expression:

=(sum(if(S5_Month2>='1/1/2016', if(S5_Month2<='5/1/2016',([S5_Leads]))))

-sum(if(S5_Month2>='1/1/2015', if(S5_Month2<='5/1/2015',([S5_Leads])))))

/sum(if(S5_Month2>='1/1/2015', if(S5_Month2<='5/1/2015',([S5_Leads]))))

With your help i have completed the first expression i.e.

=(sum(if(S5_Month2>='1/1/2016', if(S5_Month2<='5/1/2016',([S5_Leads]))))..

Now i need to achieve the second expression i.e.

-sum(if(S5_Month2>='1/1/2015', if(S5_Month2<='5/1/2015',([S5_Leads])))))

If  i give add months and in the filter if i select May-2016 it is showing as May-15 but i need to get Jan-15 if i select May-2016.

[settu_periasamy · Accepted solution]

Have you tried, what i have given for 2015? it is working for me..

and, do you still need if condition?

[bharatkishore]

Thanks a lot...Sorry My bad didn't check... thank u so much...