## Unanswered: Formula Stopped Working Correctly

Thank you all for your help,
All the formulas were working great until I got to Race. Now it doesn’t seem like the Mean with Ovg Pts is subtracting with the -Mean with Ovg Pts.
Is there another way I should be doing this?

[code]

AM_AN_Diff: Sum(IIf([Race]='White',[Mean with Ovg Pts],IIf([Race]='American Indian or Alaskan Native',-[Mean with Ovg Pts],0)))

AM_AN_Diff_Mean with Ung Pts: Sum(IIf([Race]='White',[Mean with Undg Pts],IIf([Race]='American Indian or Alaskan Native',-[Mean with Undg Pts],0)))

AM_AN_Diff_Incidence with Ovg Pts: Sum(IIf([Race]='White',[Incidence with Ovg Pts],IIf([Race]='American Indian or Alaskan Native',-[Incidence with Ovg Pts],0)))

AM_AN_Diff_Incidence with Undg Pts: Sum(IIf([Race]='White',[Incidence with Undg Pts],IIf([Race]='American Indian or Alaskan Native',-[Incidence with Undg Pts],0)))

Asian_PI_Diff_Mean with Ovg Pts: Sum(IIf([Race]='White',[Mean with Ovg Pts],IIf([Race]='Asian or Pacific Islander',-[Mean with Ovg Pts],0)))

Asian_PI_Diff_Mean with Ung Pts: Sum(IIf([Race]='White',[Mean with Undg Pts],IIf([Race]='Asian or Pacific Islander',-[Mean with Undg Pts],0)))

Asian_PI_Diff_Incidence with Ovg Pts: Sum(IIf([Race]='White',[Incidence with Ovg Pts],IIf([Race]='Asian or Pacific Islander',-[Incidence with Ovg Pts],0)))

Asian_PI_Diff_Incidence with Undg Pts: Sum(IIf([Race]='White',[Incidence with Undg Pts],IIf([Race]='Asian or Pacific Islander',-[Incidence with Undg Pts],0)))

Black_Diff_Mean with Ovg Pts: Sum(IIf([Race]='White',[Mean with Ovg Pts],IIf([Race]='Black',-[Mean with Ovg Pts],0)))

Black_Diff_Mean with Ung Pts: Sum(IIf([Race]='White',[Mean with Undg Pts],IIf([Race]='Black',-[Mean with Undg Pts],0)))

Black_Diff_Incidence with Ovg Pts: Sum(IIf([Race]='White',[Incidence with Ovg Pts],IIf([Race]='Black',-[Incidence with Ovg Pts],0)))

Black_Diff_Incidence with Undg Pts: Sum(IIf([Race]='White',[Incidence with Undg Pts],IIf([Race]='Black',-[Incidence with Undg Pts],0)))[\code]