Best Possibility to get the count of year using fisical year

[#1]

Hi All,

            I have a small requirement, Where i  have the field year,

2011 (2010-2011), 2012(2011-2012), 2013(2012-2013),2014(2013-2014), For these years of data, if i don't select any year then it should be consider 2014 count should be 3.

Else

        if i select the year specifically, then it should come the output as in excel.

Note: i got the solution using of yearname function.

Regards,

Ravi.

[vincent_ardiet]

Hi,

Can you be more specifics ?

In your XLS example 2014 is associated to 3 not to 4. How does this excepted value come from ?

Regards,

Vincent

[#3]

Hi,

     You are right, by mistake i have put the value four, it should be three.

Regards,

Ravi.

[vincent_ardiet]

Try with this set analysis :

{$<Year={'$(=max(Year))'}>}

If you have no selection, it will retain only the last one, else the one you selected (but you can't have more than one year).

[#5]

Hi Vincent,

                Thanks for your reply, But have you understand my requirement what exactly i am looking for that. Your solution doesn't helpful, can you try in some different manner.

Regards,

Ravi.

[vincent_ardiet]

Yes perhaps I have not understood.

I have think that you want to obtain the values of year 2004 when no year is selected, and, if a year is selected, values from this particular year.

May be can you illustrate your requirement with some scenario example ?

Regards,

Vincent

[#7]

Hi,

   Let  me explain you clearly,(Finanical Year is April to march).

    We have the data for

Year         FisicalYear 

2011          2010-2011        (Here data start from jan 2011, So we don't have the data for 2010, then it should not consider.)

2012          2011-2012

2013          2012-2013

2014          2013-2014    

Regards,

Ravi.   

[#8]

Hi All,

               We got one of the best solution for this. Just treat it this post is closed.

Regards,

Ravi.