Looks Like Percent-1 is aggregated already,so try this:
IF ATTR( [State])<>"Missing" THEN ([percent-1]+0.09) Else [percent-1] END
The above should work for [Percent-2]
Thanks. This works partially because it is not a dynamic fix. In other words if the value of "Missing" gets updated in the data source, then I would like to have the calculated field to automatically update the value in Percent-2. Also, I would like to omit the value for "(Missing)" in Percent-2 since its value has already being added to the other state items.
Please attach a workbook and expected results.