Looking help with formula

If any of the provider type codes is listed and does not have a BHNOMCR flag,

Then add comment of BHNOMCR Check Claims

Else Ineligible Provider type

(it's flagging all other provider types not listed below as Ineligible Provider Type) Thank you

If [PT Code] IN ("ABA",
"ACM",
"ADC",
"AFH",
"ALC",
"AT",
"BAA",
"BB",
"BC",
"BT",
"CS",
"DHB",
"DHY",
"DLA",
"DNT",
"ECS",
"GNC",
"HMD",
"HOM",
"IDN",
"LC",
"NSA",
"PC",
"PE",
"PER",
"PSS",
"SBH",
"SDC",
"SES",
"VIP")
AND (!Contains([Flag Code], "BHNOMCR"))
Then "BHNOMCR Check Claims"
Else "Ineligible Provider Type"
EndIF

Developer

Accepted answers

All comments

binu_acs

@snadeau456 i dont see any issues with the formula, can you provide the input file and expected output

snadeau456

I removed all of the other columns for confidentiality reason.

alteryx assist .xlsx

snadeau456

binu_acs

@snadeau456 Your formula working fine. I added a filter tool to see how many records are falling in the given Prov Type codes. you can remove the filter tool

BHNOMCR_20062024.yxmd

snadeau456

In the results provided, it is not.

binu_acs

@snadeau456 your logic is

AND (!Contains([Flag Code], "BHNOMCR"))
Then "BHNOMCR Check Claims"
Else "Ineligible Provider Type"
EndIF

eg: ProType = 'ABA'

AND (!Contains([Flag Code], "BHNOMCR")) means it will check for the word BHNOMCR, if it is there then mark as "BHNOMCR Check Claims"

thats why the result are

what is your expected result then

mkeiffer

@snadeau456 I updated the formula that @binu_acs initially created. I think this might give you the output that you are looking for. See attached workflow.

BHNOMCR_20062024.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703