Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Have you tried, what i have given for 2015? it is working for me..
and, do you still need if condition?
Thanks a lot...Sorry My bad didn't check... thank u so much...