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

Connection Problem with Excel Add-In Series 4 - No Customer
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
explainability results is blank into model
Why in my model output is blank, after send explainability data.
How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…