## Previous Period Lookup

Occasional Contributor

## Previous Period Lookup

Hi

I have a module where I look up the last period with data entered - line item Previous Non-Blank.

My formula is as follows - why in Q4 FY20 and Q1 FY21 is the previous non-blank not picking up Q3 FY20 and Q4 FY20?

Formula: IF Last Quarter Entered = Last Quarter Entered[SELECT: TIME.All Periods] AND ITEM(Time) >= Last Quarter Entered[SELECT: TIME.All Periods] THEN PREVIOUS('Previous Non Blank') ELSE PREVIOUS(Last Quarter Entered)

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Certified Master Anaplanner

## Re: Previous Period Lookup

@CommunityMember113484  I would use this formula instead:

IF PREVIOUS(Data) <> 0 THEN PREVIOUS(ITEM(Time)) ELSE PREVIOUS('Previous non Blank')

Hope it helps

Alex

2 REPLIES 2
Certified Master Anaplanner

## Re: Previous Period Lookup

@CommunityMember113484  I would use this formula instead:

IF PREVIOUS(Data) <> 0 THEN PREVIOUS(ITEM(Time)) ELSE PREVIOUS('Previous non Blank')

Hope it helps

Alex

Occasional Contributor

## Re: Previous Period Lookup

Worked a treat, thank you!