Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Creating custom column based on 3 other colums

HI,

 

Please help me to create a custom colum based on 3 other colums.

1. if patient type is OP then custom colum should reflect OP.

2. If patient type is only IP and Sponsor is only blank and Net amount less than 1000 then OP others as IP.

 

basically, the custom colum should reflect as the below.

 

Patient TypeSponsorNet AmtCustom colum
IPPayer - Y490IP
IP 47OP
IP 4200IP
OPPayer - Y300OP
OP 25OP
OP 2100OP
Need Help
Tips and Tricks
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi Anonymous 

     

    Your net amount column is text please convert into interger / whole number.

    select your net amount then convert to whole number.

     

11 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    2 years ago

    Hi Anonymous 

     

    You are basically there with how you outlined your reuqirements.

     

    CustomColumn =
IF(Table[Patient Type] = "IP" &&
Table[Sponsor]= BLANK() &&
Table[Net Amt] < 1000, "OP",
IF(Table[Patient Type] = "OP", "OP", "IP")

     

    Hope this helps

    Joe

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks joe for your input. But i am getting the same error as below.

       

       

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi Anonymous 

     

    You can try below calculated column.

    Custom new =
    IF(Customer[Patient Type]="OP","OP", If(Customer[Patient Type]="IP" && Customer[Sponsor]=BLANK() && Customer[Net Amt]<1000,"OP","IP"))
     

     

     

    I hope i answered your question!

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thank for your input. 

      But I am getting the below error. can you please help.

       

      • Uzi2019's avatar
        Uzi2019
        Community Champion
        2 years ago

        Hi Anonymous 

         

        share your formula also...
        bcz by looking at error wont able to understand you formula mistake.