Skip to main content

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

 

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

 


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


Reply