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

Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…