Forum Discussion
Anonymous
4 years agoNot applicable
Set fixed amount based on text of other column
Hey all,
I am trying to set a fixed amount based on a text from another column.
The column that contains the text (text = 'series') is called ALG_Omschrijving. The fixed amount has to be 10.
Does anyone know how this can be achieved? I've tried some stuff with text.contains but that doesn't work for me.
Thanks!
Hi Anonymous ,
Is it this you are looking for? 🙂
Here the code:
if Text.Contains([ALG_Omschrijving], "series") = true then 10 else null
Let me know, if this solves your issue! 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
2 Replies
- tackytechtom
Most Valuable Professional
Hi Anonymous ,
Is it this you are looking for? 🙂
Here the code:
if Text.Contains([ALG_Omschrijving], "series") = true then 10 else null
Let me know, if this solves your issue! 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/- AnonymousNot applicable
Worked perfectly! Thank you!