Finding the next non blank field

DeveloperCYT
DeveloperCYT
in Modeling

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

 

Tagged:

Best Answer

  • DeveloperCYT
    DeveloperCYT
    Answer ✓

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

     

    MOVINGSUM(Date, 1, 52, FIRSTNONBLANK)

     

    thanks

     

Comments

  • rob_marshall
    rob_marshall

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

     

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

     

    Rob

     

Categories