Hi All,
Just want to check what tool or script i can use that i can apply a formula on the branch column if its NULL just retain the value if its not NULL.
Thanks
Rob
Hi Rob,
Since you only want to apply the formula when the Branch is null, it's important to include that in the formula, just in case other rows have counterparts that begin with C or D.
Love the use of StartsWith instead of Left!
IF IsNull([Branch]) THEN IF StartsWith([Counterparty], "C") THEN "AG SCF"
ELSEIF StartsWith([Counterparty], "D") THEN "AG SCF"
ELSE [Branch]
ENDIF
if you want to repeat the branch in subsequent rows, if they are NULL,I would recommend to use a Multi Row Formula tool.
Formula would be like:IF IsNull([Branch]) THEN [Row-1:Branch]ELSE [Branch]ENDIF
Is that what you want to do?
Best regards
Roland
Hi Roland,
Actually i will be applying formula for those NULL row that if Counterparty starts with C or D then Branch = AG SCF.
Can i use the Multirow formula as well?
Thanks,
Will take note of it. Thanks for the reminder
