If else statement with calculated return values

[akhildesa92]

Hello Team,
I am facing a issue to return a calculated return statement using if else statement.
Please suggest the best nodes to solve this case

Data Set
Col1: Group1
A
B
C
D

Col2:PY Rate
1
2
3
4

Col3: FY Rate
4
3
2
1

Required Output Column
4
0.66
0.66
4

Logic:
if Col1 = {“A” , “C”}
Return Col3 / Col2
Else
Return Col2 / Col3

Thank You

[AlexanderFillbrunn]

Hi,
You can use a Column Expressions node with the following expression:

column("Col1") === "A" || column("Col1") === "C" ? (column("Col3") / column("Col2")) : (column("Col2") / column("Col3"))

Kind regards,
Alexander

[akhildesa92]

Hello Alexander,
This works perfectly.
Thank you for the solution …