Del
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Convert number to decimal
Looking to have a field on a form that can accept an entered fraction 1/8, a percent entered as 25%, Decimal .05 or an integer and have it display as a decimal in any case. Do I create a separate formula field? ------------------------------ Del ------------------------------Re: Formula Fields
Here is the formula IF( [Service Type Authorization Description] = "Agency Hired Respite", "Empower U. Services Corp", [Service Type Authorization Description] = "Intensive In-Home Clinical - Licensed Level" AND [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC", [Service Type Authorization Description] = "Intensive In-Home Clinical - Masters Level" AND [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC") ------------------------------ Del ------------------------------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 #] = 12345, [Provider Tax ID] = 5555, [NPA #] = 5555 If [Service Type Authorization Description] = 'Flight 10' OR 'Flight 11' AND [Responsible Payer] = 'Paid', then [Providing Agency] = 'Jetplace Services', [Provider ID #] = '6789', [Provider Tax ID] = 6666, [NPA #] = 6666 Formula Text Fields; Providing Agency Provider Id # Provider Tax ID NPA # ------------------------------ Del ------------------------------
