Forum Discussion
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...
Hi Anonymous
Your net amount column is text please convert into interger / whole number.
select your net amount then convert to whole number.
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"))
Hi Anonymous
Your net amount column is text please convert into interger / whole number.
select your net amount then convert to whole number.
It worked. Thank you so much.