I am facing a challenge to calculate the below information:
Requirement was :
RAG status of Red > 1 month
Amber status > 3 months
Not Reported > 45 days, and(from database itself we are getting more than 45 days information for N/R)
% = (Red > 1 month + Amber > 3 months + N/R > 45 days ) / Total investments
Issue 1 :I can able to calculate the a, b, c in different sheets(PFA workbook).(How I have achieved: each sheet I have changed the snapshot month filter based on the requirement). But as per the requirement we should display everything in single sheet
Issue 2 : I am unable to get the % calculation due to changing the snapshot date filter based on requirement for each RAG.