Formula

imivan

Tax Code Document No Posting Date
S0 1800027553 01.04.2020 1800027552 01.04.2020
...
SG 1800027994 01.05.2020 1600001562 22.05.2020

The tax code only appears once which means before the next tax code appear, all the tax codes which are currently null) will follow the previous one. Is it possible to do conditional value assign by assigning the tax code to all the null fields in this case using formula tool, eg. before null tax code SG are all S0

davidskaife

Hi @imivan 

I'm assuming you mean turning this:

 

Into this?

I've attached a workflow that uses the Mutli-Row Formula tool to check if the field is empty, and to use the data from the field above if it is

Let me know if this isn't what you were looking for!

New Workflow1.yxmd