Hello,
I am working on a formula that is giving me trouble. I have been successful until I ask it to multiply based on a condition (highlighted)... any ideas??
(Staff_Requirement / 2 + if((Living_Situation == "Community"),1,0) + if((Intensive_Family_Involvement == "Yes"),2,0) + if((Split_Shifts == "Yes"),2,0) + if((Payee == "Yes"),1,0) + if((BSP == "Yes"),1,0) + if((Monthly_Medical == "2 or Less"),1,0) + if((Monthly_Medical == "3 to 4"),2,0) + if((Monthly_Medical == "5 or More"),3,0) + if((Delegated_Nursing = "Yes"),1,0) *
if((Shared_Site == "Yes"),0.8,1).round(2)
Thanks
Nick