Formula Fields
I am in need of a formula with a few conditions. See criteria below
If [Service Type Authorization Description] = 'Agency Hired', then [Providing Agency] = "Airplane Services", [Provider ID #] =...
Forum Discussion
Here is the formula for Providing Agency
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
IF(
[Service Type Authorization Description] = "Agency Hired", "Airplane Services",
[Service Type Authorization Description] = "Flight 10" AND [Responsible Payer] = "Paid", "Jetplace Services",
[Service Type Authorization Description] = "Flight 11" AND [Responsible Payer] = "Paid", "Jetplace Services")
Post back if you have any problem with the other three formula fields.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Del
------------------------------
- Del would you please copy and paste the code into the thread here and I will try it in my own app?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- .. also please confirm that the field type is formula text.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- I tried the code here and it worked.
IF(
[Service Type Authorization Description] = "Agency Hired Respite", "Empower U. Services Corp",
[Service Type Authorization Description] = "Intensive In-Home Clinical" AND [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC",
[Service Type Authorization Description] = "Intensive In-Home Clinical" AND [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
