Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How can I change values in a specific column depending on values of other columns?

Hi,   I created a duplicate of the column "Einzeldauer" and named it "Ersatzstunden". The column "Einzeldauer" must stay untouched.   1. If a cell in column "Grund Abwesend" is "Feiertag" and the...
Need Help
  • JorgePinho's avatar
    JorgePinho
    3 years ago

    Hello Anonymous !

     

    My suggestion is:

     

    1. Delete the current Ersatzstunden column you have

    2. Add Column > Custom Column and try this 

     

    if [Grund Abwesend] = "Feiertag" and Text.Contains([Kommentar], "ÜÜ") then [Einzeldauer]
else if [Grund Abwesend] = "Feiertag" and Text.Contains([Kommentar], "ÜÜN") then Value.Multiply([Einzeldauer],-1)
else null
JorgePinho's avatar
JorgePinho
Icon for Solution Sage rankSolution Sage
3 years ago

Hello Anonymous !

 

My suggestion is:

 

1. Delete the current Ersatzstunden column you have

2. Add Column > Custom Column and try this 

 

if [Grund Abwesend] = "Feiertag" and Text.Contains([Kommentar], "ÜÜ") then [Einzeldauer]
else if [Grund Abwesend] = "Feiertag" and Text.Contains([Kommentar], "ÜÜN") then Value.Multiply([Einzeldauer],-1)
else null
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you very much. It works not as expected as the first "ÜÜ" already fulfills the "if" and so "ÜÜN" will never be identified. Once I changed "ÜÜ" to "ÜÜP" in my source files and changing the formula as follows ist works fine:

 

if [Grund Abwesend] = "Feiertag" and Text.Contains([Kommentar], "ÜÜP") then [Einzeldauer]
else if [Grund Abwesend] = "Feiertag" and Text.Contains([Kommentar], "ÜÜN") then Value.Multiply([Einzeldauer],-1)
else null