Previous Period Lookup

CommunityMember113484
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)

 

CommunityMember113484_0-1619694691630.png

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
alexpavel
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')

 

alexpavel_0-1619698944906.png

 

Hope it helps

Alex

 

View solution in original post

2 REPLIES 2
alexpavel
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')

 

alexpavel_0-1619698944906.png

 

Hope it helps

Alex

 

View solution in original post

CommunityMember113484
Occasional Contributor

Re: Previous Period Lookup

Worked a treat, thank you!