Dears,
I tried to use the formula IN and it seems to not be available anymore
IN function | Community (gopigment.com)
I just want to add a boolean formula in a trasancation to get back true when I have a dimension in another column = “ XXX”
Thank you very much in advance
BR ,
Jose
Best answer by Ben A
View originalDears,
This is what I try to do in the formula
I can do a workaround of converting to text my dimension then do the formula, but I wanto to avoid creating more columns.
Thank you very much in advance!
BR,
Jose
+3
Hello Jose,
The IN function is still available.
I believe the syntax you use here is not correct though. You should put it this way: IF(‘Payfit import’.Category = Category.”Salaire brut”, True)
Or using the IN syntax:
IF(Payfit import’.Category IN (Category.”Salaire brut”), True)
Hello Ben,
Both ways work well! thanks for your reply!
I thought the IN fuction was not working because its in black color
Best Regards,
Jose
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
