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 Ne...
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.

     

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.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks in advance.

     

    custnew = IF('12#06#2024'[Patient Type]="OP","OP", IF('12#06#2024'[Patient Type]="IP" && '12#06#2024'[Primary Bill Sponsor]=BLANK() && '12#06#2024'[Net Amt]< 1500, "OP", "IP"))
     

     

    • Uzi2019's avatar
      Uzi2019
      Community Champion
      2 years ago

      Hi Anonymous 

       

      Did u take column right not measure???

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Yes sir.  Under Modeling - new column

    • Uzi2019's avatar
      Uzi2019
      Community Champion
      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        It worked. Thank you so much.