Hi I need to replace the null values with values existing previously for the same Code, as these records are co-ordinates. they might not change over time. So I just need to pull the new dates with values existing in NUmber1, NUmber2 column,
Below an example, ss attached.
Hey @Ronal_bal,
A multi row formula can do this, it can grab values of the row above:
The formula checks for null, if yes grab the row above.
Any questions or issues please ask :)
HTH!
Ira
A couple of MultiRow Tools should solve this,
if isnull([Number1]) then [row-1:Number1] else [Number1] endif
And again for the number2. Be sure to group by Code column.
If there is only one filled value, I suppose you might get away with a Running Total Tool too. :)
@Ronal_bal, another way of solving this problem in case it occurs for multiple columns.
I hope this helps!
Thanks!