Forum Discussion

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

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

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
Community Champion
2 years ago
Hi Anonymous

Did u take column right not measure???
- Anonymous
  Not applicable
  2 years ago
  Yes sir. Under Modeling - new column
  - Uzi2019
    Community Champion
    2 years ago
    Hi Anonymous
    
    error you are getting for type conversion it means your either of the column is text and comparing with numeric value<1000 or either of your column is numberi comparing with text value "OP" /"IP"..
    
    Please check that..
    
    I\
    
    I hope it may resolved your issue!
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
  Not applicable
  2 years ago
  It worked. Thank you so much.

Forum Discussion

Creating custom column based on 3 other colums

Related content

Creating a custom column

create custom column concatenated

Creating Custom columns

Creating custom columns keeps returning a structured Table column

Create a custom column