I'm trying to figure out how I can create a column that takes the value in VH based on emp status = "Terminated". I think I'm over thinking something so simple. Let me know if there is any solution out there.
If [empstatus]="Terminated" then [VH] else null() endif
If you are creating a new columns, using this as the formula should do it.