Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 Type | Sponsor | Net Amt | Custom colum |
IP | Payer - Y | 490 | IP |
IP | 47 | OP | |
IP | 4200 | IP | |
OP | Payer - Y | 300 | OP |
OP | 25 | OP | |
OP | 2100 | OP |
Solved! Go to Solution.
Hi @Prasanthh60
Your net amount column is text please convert into interger / whole number.
select your net amount then convert to whole number.
Hi @Prasanthh60
You can try below calculated column.
I hope i answered your question!
Thank for your input.
But I am getting the below error. can you please help.
Hi @Prasanthh60
share your formula also...
bcz by looking at error wont able to understand you formula mistake.
Thanks in advance.
Hi @Prasanthh60
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.
Hi @Prasanthh60
Did u take column right not measure???
Yes sir. Under Modeling - new column
Hi @Prasanthh60
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!
Hi @Prasanthh60
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
Proud to be a Super User! | |
Date tables help! Learn more
Thanks joe for your input. But i am getting the same error as below.
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
52 | |
41 | |
39 | |
37 |