Column Expression simple help needed

wethernt · February 27, 2025, 3:33pm

Greetings,

I have something wrong with my column expression. Please see attached workflow file (image below).

Probably something really stupid I don’t see.

Thank you for any assistance.

MartinDDDD · February 27, 2025, 6:20pm

Can you maybe explain what you want to return for each scenario? From what I can see in the demo it is always “DONATED;VALUE: $xx”. Does it differ?

In general I can see some potential issues with your nested ifs:

red square: that one is right now doing nothing - the if is entirely completed and there is more code below it that will overwrite if Class = B.
green square: that right now seems to be the main logic that gets executed, however it only covers various Class “letters” for Level 1.
orange square: this part of code is never reached - it is nested inside Class = G so if Class is not G then it goes to the last else
yellow square: This one is also in a weird position

In general there are some combinations where you actively have defined to show " " - e.g. Class = D, E, G combined with Projlevel 1.

wethernt · February 28, 2025, 12:37pm

Hello and thank you!

Your question is spot on. I apologize for not being more clear.

I have uploaded here a UPDATED workflow (noticed I had a variable name wrong).

I have also uploaded an Excel file that shows the expected results.

I guess this is perhaps not a so easy formula but maybe - not sure. I get twisted up with all the nesting and syntax.

Thanks so much for any assistance.

TW