Hi,
I am new member, saw the views most of the people who got stuck in getting their results solved in simple steps thanks for the team
I need your help to put the formulas to the get the desired results based on conditions, I have more than 10000 lines items attach the sample for your reference
Condition1
To check for 2012/13 records based on ACTUAL_START_DATE & pull the related rows data, if he has more than one line for the period 2012/13 we need to check Fiscal Year (6th April 2012 to 5th April 2013) for which period he will fall & pull that records
Condition2
To check the latest records based on ACTUAL_START_DATE & pull the related rows data keeping
Please guide
Bookmarks