Pulling value from one field if another field is Null

[tj3678]

Hi everyone,

Back again in need of some help.  See data sample below - I am trying to pull the value from VALUE_RETURN field when the CREDITVALUE_PMT field is blank/null and place in a new column.  much appreciated!

[JosephSerpis]

hi @tj3678 this might solve your problem please let me know if it doesn't?

[tj3678]

Thanks @JS420 ! This worked! 

May I ask one more scenario - what if I wanted to replace the null value in CREDITVALUE_PMT with the value in VALUE_RETURN?  

[JosephSerpis · Accepted solution]

HI @tj3678 

                   I kept the previous formula but also as requested created a new formula which will replace null value CREDITVALUE_PMT with the value in VALUE_RETURN. I also attached the workflow as well. If this solution been helpful could I ask you mark this as being solved please? 

[tj3678]

Thanks again!

[Madhu-Navuluri]

@JosephSerpis

you are answer solved my issueue

Thanks,

Madhu