Forum Discussion

DavidB023's avatar
DavidB023
Helper III
8 years ago

If with two column

  Hi everybody !   I want to create an if function between two tables.   In fact, if I have nothing in a specific column in my second table, my personalize column (my function) take the number 3...
Need Help
quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi DavidB023

 

You can simply use = or <> with LEFT() or RIGHT()

 

For example your date is 01/01/2018 and you want to verify if it contains 2018 type :

 

Column = IF(RIGHT(Table[DateColumn];4)="2018";0;3)

 

Hope this help

 

- Quentin