Need a help to resolve issue get formula

[rojan]

Hi ,

can I get a help to resolve below issue. From below table i want to get data in such a manner. if column 2 is blank then I want to get data from 3 column other wise from column 1.

And I tried below formula but it does not work

IF ISNULL([COLUMN2])THEN[COLUMN3] OTHERWISE[COLUMN1] endif.

1	2	3
ab	ad	ca
	ma
cd
		tb
cb		dk

Thanks

Rojan

[HomesickSurfer]

Hi @atcodedog05 

I like it!...swapped the priority per @rojan 's [2][3][1] requirements.

IF !IsEmpty([2]) THEN [2] // First priority
ELSEIF !IsEmpty([3]) THEN [3] // Second priority
ELSEIF !IsEmpty([1]) THEN [1] // Third priority
ELSE Null() ENDIF

[rojan]

Thanks for below solution and its working!

One more question if I want to make new column based on below input .

input column
a	10
a	10
a	10
b	30
b	30
b	30
c	20
c	20
c	20

desired output
a	30
b	90
c	60

[atcodedog05 · Accepted solution]

Hi @rojan 

Is this what you are looking for. Groupby and sum.

Hope this helps : )

[HomesickSurfer]

I concur.

@rojan do u require the blank/empty first row a over the summary?

[rojan]

Hi,

Thanks , its working

Rojan

[atcodedog05]

Happy to help : ) @rojan 

Cheers and have a nice day!

[rojan]

Hi ,

I need a help to resolve below issue . 

	Problem
	Name	amount
1	Diversifying	300
2	Diversifying prospectus	200
3	Diversifying strategies	500

I want to merge below input with common name and get total amount

Desired output
Diversifying	1000

regards

Rojan

[Elias_Nordlinder]

Hello @rojan ,

It is best to create a new post if you have a different question from the original one.

Otherwise it will be confusing to find which answer is to which question if someone is searching for this topic later, as well as which is the accepted answer.

If you create a new topic I can take a look at it 🙂

//Regards

Elias