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
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)
Dears,
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
+3Hello 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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
