Multi row formula

[Sarath27]

Hi All, Pls help me writing multi-formula for below scenario

Level	Default Level	Final Level
1	[null]	1
2	3	3
2	2	2
[null]	1	1

[DataNath]

@Sarath27 please can you tell/show us the starting state of your data. Do you only have [Level] to start with? Do you have all 3 fields and need to populate them? We have no idea. Would be great if you could also explain the logic or process so that we can help build out an expression. At the minute we can only guess at what you want.

[PhilipMannering]

I'm guessing something like this should do the job (in the Formula Tool),

if not isnull([Default Level]) 
then [Default Level] else [Level] endif

[caltang]

Hey @Sarath27 what are you even asking for? 

Can you provide more details please?

[Raj]

this can be achieved by max function as well.