Finding the next non blank field

DeveloperCYT
Regular Contributor

Finding the next non blank field

Hi,

This must be simple but it is driving me mad

nextnonblank.PNG

What formula do i need in the Next Non Blank line item to find the next non blank date?

 

Thanks

 

4 REPLIES 4
DeveloperCYT
Regular Contributor

Re: Finding the next non blank field

Ok it was simple, but I will leave it here anyway

 

MOVINGSUM(Date, 1, 52, FIRSTNONBLANK)

 

thanks

 

rob_marshall
Moderator

Re: Finding the next non blank field

@DeveloperCYT 

 

Well done...Quick question, instead of using the MOVINGSUM() function, could you just enable the summary for FirstNonBlank?

 

2021-01-20_09-57-56.png

 

Rob

DeveloperCYT
Regular Contributor

Re: Finding the next non blank field

I did try referring to DATE and then using First non blank in summary, but it brought the current date back, no the next one.
rob_marshall
Moderator

Re: Finding the next non blank field

@DeveloperCYT 

 

Did you try using YearValue?  This assumes you don't want to span the year which I believe your MovingSum does since it is a rolling time period.  Again, happy you figured it out, I was just wondering if this alternative way would have worked for you.

 

2021-01-20_10-06-20.png

 

Rob