Formula

[AlterMini]

i need a formula to get Column D as shown below based on column B (Region Left) & C (Region Right). Both columns are string types. If data is there in both column, it will be same

Sample of the data

Record      Region Left     Region Right       Required new column

1                East                                               East

2                                        West                     West

3               North                 North                    North

4               South                South                    South

[MarqueeCrew]

@AlterMini ,

 please try:

max([region left],[region right])

 cheers,

 mark

[Hammed]

Hi @AlterMini,

try this

IF ISNULL([Region Left ]) THEN [Region Right] ELSE [Region Left ] ENDIF

[atcodedog05 · Accepted solution]

Hi @AlterMini 

Another way of doing it

IIF(!IsEmpty([Region Left]), [Region Left], [Region Right])

Workflow:

Hope this helps : )

[AlterMini]

Thanks MarqueeCreq, Hammed and Atcodedog05

Suggestions from Marquee and Atcodedog05 works well. Still Region right is missing in Hameed formula.