Adding Additional Column from Formula

[chughes49]

I currently have this

Fac Name	MonthAct	MonthVar
Main	2345	412
Elk	23542	312
ein	213	123
emc	412	142

I am trying have this though:

where there is a new column (Entity)

and if fac name=main Philly

and if facname=elk than it gives Mont

I am stuck right here:

IF([Fac name] IN(Main) THEN 'Philly')

Thanks!!

Entity	Fac Name	MonthAct	MonthVar
Philly	Main	2345	412
Philly	Elk	23542	312
Mont	ein	213	123
Mont	emc	412	142

[DataKyle · Accepted solution]

So you need something like this?

IF([Fac Name] = 'Main') THEN 'Philly'

ELSEIF([Fac Name] = 'Elk') THEN 'Mont'

ELSE NULL ENDIF

You can also add other options before the last else if needed.

[bpatel]

try this

if [Fac Name] = "Main" OR [Fac Name] = "Elk" then "Philly" else "Mont" endif

hope this helps.

[chughes49]

Is it possible to return an empty value instead of null?

[bpatel]

Yes instead of writing null in the formula just add "" (empty quotation marks).