Fiscal year VS.calendar year calculation

[abc_18]

Hi,

In Master calendar I have two year field one for fiscal year and other for calendar year.(Fyear(Oct-Sep),Year(Jan-Dec))

I need to calculate FY'15, FY 16 Actuals value.(Two Calculated field).so for Intel division we need to use calendar year(Year) and for others division need to use Mater calendar(Fyear).

Likethis:-

if(Division='Intel',sum(value)based on Calendar year,otherwise sum(value) based on fiscal year).

Please  help me out in this..sample file is attached.

[abc_18]

Hi,

Any Suggestion how can I get this logic implemented??

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[abc_18]

Hi Gysbert,

Thanks a lot for your reply.

our requirement is like FY'15  and FY'16 should come in two different calculated column, with year ,month and quarter as filter  and project actual is nothing but some of these two that is:

project actual=( FY'15  + FY'16).

I have linked excel data with master calendar, after that I am getting year , month and quarter filter.