Results showing as null when trying to do formula for disposal year/month

[adelossantos]

I am trying to do the formulas for placed into service year/month and disposal year/month. The service year and month are showing but when I try to do the same for disposal, the results are showing null. What is a way to fix this? I've attached my workflow for reference.

[Sebastiaandb]

@adelossantos ,

Can you add the data as well (or package the workflow via options export workflow). Then we can have a look at your data as well :-).

Greetings,

Seb

[DataNath]

@adelossantos are you able to attach the Excel file you use as your input, or package your workflow as a .yxzp instead? Saving as a standard worklow (.yxmd) doesn't package your data and therefore we can't use your workflow at the minute.

[Jonathan-Sherman]

Hi @adelossantos,

Could you attach the data for the workflow too?

Kind regards,

Jonathan

[adelossantos]

Hey guy, appreciate the responses. I think I uploaded the workflow and data correctly.

[DataNath · Accepted solution]

Thanks @adelossantos, that's perfect. The issue here though isn't with your formula - that works perfectly. The issue is that the majority of your Disposal dates themselves are null and therefore applying this function to them will return null values. The reason you get [Null] in the formula tool window is that Alteryx shows you a preview of the first row's result. However, if we look at the data after applying this, you can see that there are a handful of outcomes that are returned as expected because they have a populated disposal date: