Forum Discussion

bilingual's avatar
bilingual
Helper V
6 years ago
Solved

Related table with different filter functions

Hi i have a data table with following where i have a lot of entries like:   ENTRY PART OF ENTRY WHICH DEFINES TYPE AAHEPX XXXPX DKDEFX XXXFX 5DKDKE 5XXXX 6EOEEM 6XXXX 7ENEEG ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi bilingual ,

     

     

    Column = SWITCH(
    TRUE(),
    SEARCH("FX",'Table20'[ENTRY],1,0) > 0 , "Public Export",
     SEARCH("7",'Table20'[ENTRY],1,0) > 0 , "Local Export",
      SEARCH("S2OLDC",'Table20'[ENTRY],1,0) > 0 , "Special Export"
)

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

     

bilingual's avatar
bilingual
Helper V
6 years ago

Hi again, so sorry, can see it is not very clear writtten, i try again with an example, how it is working in SAP:

 

ENTRYPART OF ENTRY WHICH DEFINES TYPETYPE DEFINED FROM PART OF ENTRYCURRENT SAP FORMULA
DKDEFX"FX"Public export=If(Substr(Trim([ENTRY]);4;2))="PX") Then "Public export"
7ENEEG"7"Local export=If(Substr(Trim([ENTRY]);1;1))="7") Then "Local export"
S2OLDCS2OLDCSpecial export=If(Substr(Trim([ENTRY]);1;6))="S2OLDC") Then "Special export"

 

All entries have a length of 6 characters