Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

How to force G16 recode to AO ?

Hi All I have below workig fine expression from Anonymous  which recode the field GROUP_TYPE into only those value label i want to see :-   GROUP_TYPE_C = IF ( ISBLANK('Group TYPE'[GROUP_TYPE]), ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    admin11 , Try like this as we are using a function that works on  *value*, it means G16 should come before G1

     

    GROUP_TYPE_CO = 
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE('Group TYPE'[GROUP_TYPE_C],
"G16","AO"),
"G2","AP"),
"G3","SL"),
"G4","CL"),
"G5","RW"),
"G1","GT")
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

admin11 , Try like this as we are using a function that works on  *value*, it means G16 should come before G1

 

GROUP_TYPE_CO = 
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE('Group TYPE'[GROUP_TYPE_C],
"G16","AO"),
"G2","AP"),
"G3","SL"),
"G4","CL"),
"G5","RW"),
"G1","GT")
admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago

amitchandak 

no wonder you are supper user