Forum Discussion
Custom Column: New column to categorize value as one or another
Hi,
In my master table (Claim Data Pull) there is a field named (Total Paid). I would like to create a column in that table that specifies whether or not the Total Paid amount qualifies as a "High Cost Claim", a "Medium Cost Claim", or "Neither High or Medium Cost Claim".
1) A "High Cost Claim": Greater than or equal to $50,000
2) A "Medium Cost Claim": Is Greater Than or Equal to $25,000 and less than $50,000
I tried creating / using a 'Conditional Column' but you can't specify inbetween ranges.
Please help. Thank you.
Anonymous
Add a custom column in query editor and paste this.
=if [Total Paid] >= "50000" then "High Cost Claim" else if [Total Paid] >= "25000" and [Total Paid] < "50000" then "Medium Cost Claim" else "Neither High or Medium Cost Claim"If this helps, mark it as a solution
Kudos are nice too
1 Reply
- VasTg
Memorable Member
Anonymous
Add a custom column in query editor and paste this.
=if [Total Paid] >= "50000" then "High Cost Claim" else if [Total Paid] >= "25000" and [Total Paid] < "50000" then "Medium Cost Claim" else "Neither High or Medium Cost Claim"If this helps, mark it as a solution
Kudos are nice too