Forum Discussion

jmcph's avatar
jmcph
Icon for Helper III rankHelper III
5 years ago

Value before the firstnonblankvalue

Hi, i am trying to compute for the value before the firstnonblankvalue. I am computing for Beginning Inventory of a particular model,  my date looks like this:    Date                       Particu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi jmcph ,

 

Sorry, not very clear.

 

Do you want to put the first non-blank value (100) in the Inventory table into the row of the day before the corresponding date in the calendar table?


FIRSTNONBLANKVALUE has already filtered out non-blank values, so if the value on September 30 is blank, it will continue to find the first non-blank value.

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.