Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Create column based on text-like data

Hello Community I need to create a column based on an international encoding called ISIC that goes something like this: CIIU 0990 1850 0114 3311 4560 I'm creating the column with the follo...
  • HotChilli's avatar
    HotChilli
    4 years ago

    VAR theCI = VALUE(VR_PBI_COMERCIANTES[CIIU1])

    SWITCH(TRUE,
    theCI >= 0111 && theCI <= 0322, "Agropecuario",
    theCI >= 4511 && theCI <= 4799, "Comercio",
    ....y mas
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi juandroid ,

 

I think I understand what you mean, your error is that the CIIU column is in text format, so an error occurred when running the formula. You should use VALUE() to turn your text into numbers and then compare them.

 

Should be modified to

SWITCH(TRUE,
VALUE(VR_PBI_COMERCIANTES[CIIU1])>=0111 && VALUE(VR_PBI_COMERCIANTES[CIIU1])<=0322,"Agropecuario",...

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.