3 Replies Latest reply on Sep 6, 2016 2:30 AM by Mahfooj Khan

# Previous Year Calculations

I have 3 years of Insurance data which is related to  Policies and renewals.

i want to calculate No of Policies this time last year?

How to do that,.

My out put should look like this. Thanks & Regards

Pavan Kumar

• ###### 1. Re: Previous Year Calculations

Give a try and let me know If you've any query.

COUNT(IF YEAR([Your Date Field])= {MAX(YEAR([Your Date Field]))}-1 AND

THEN [Your Policy Dimension/Measure] END)

Mahfooj

• ###### 2. Re: Previous Year Calculations

Thanks for speedy reply.

I have tried above formula.but i am getting errors.

I am attaching  my Data sheet.

Pavan Kumar

• ###### 3. Re: Previous Year Calculations

Actually your data is till July 2016. I guessed this time means this month. Anyways I've done some modification in the formula hope this help.

#This time Last Year

IF YEAR([Date])= {MAX(YEAR([Date]))}-1 AND

MONTH([Date])={MONTH(MAX([Date]))}

THEN [Total No of Policies] END

#This time Current Year

IF YEAR([Date])= {MAX(YEAR([Date]))} AND

MONTH([Date])={MONTH(MAX([Date]))}

THEN [Total No of Policies] END

Let me know If you've any query.

Mahfooj

1 of 1 people found this helpful