Solved

IN not available to use anymore?

  • 21 September 2022
  • 3 replies
  • 24 views

Userlevel 1
Badge +1
  • Enthusiastic Pigmenteer
  • 21 replies

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

 

icon

Best answer by Ben A 21 September 2022, 15:22

View original

3 replies

Userlevel 1
Badge +1

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

 

Userlevel 1
Badge +1

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)

Userlevel 1
Badge +1

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