Finding the next non blank field

[DeveloperCYT]

Hi,

This must be simple but it is driving me mad

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

Thanks

[DeveloperCYT · Accepted solution]

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

MOVINGSUM(Date, 1, 52, FIRSTNONBLANK)

thanks

[rob_marshall]

@DeveloperCYT 

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

Rob

[DeveloperCYT]

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]

@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.

Rob