Hi All,
Advance Happy New Year to you and your family!
I've a query reg Multi Row Formula. I'm not able to understand how this Update existing field and Create New field works in the configuration window. When I try to use below formula and create new field it's not updating the rows correctly while Updating existing field works as expected. Could someone pls help me out. Pls find the attached example for more insights.
Formula used: IF IsNull([Year])
THEN [Row-1:Year]
ELSE [Year]
ENDIF
