Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Any Suggestion how can I get this logic implemented??
See attached example.
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.