nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Finding the next non blank field

kevin.stevenson

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

Accepted answers

kevin.stevenson

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

MOVINGSUM(Date, 1, 52, FIRSTNONBLANK)

thanks

All comments

kevin.stevenson

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

kevin.stevenson

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

Quick Links

Can you help?

Unanswered questions

Anaplan Data Orchestrator - Numbered Lists with Display Names
Previously, we have used display names in system modules for our numbered lists and then referencing that from the list property for the display name. When using ADO though, that means creating links for each of the parts of the hierarchy as well as links to the system modules that contain the inputs for the display names.…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…