We've updated how variances are calculated in tables to make them more intuitive and consistent across the platform.

✨ What's changed

• One formula for all variables. Variance is now always calculated as A − B (absolute) and (A − B) / ABS(B) (percentage), regardless of whether a variable is favorable or unfavorable. No more sign flipping.
• Color tells the story. The variance type (favorable/unfavorable) now only determines the color: green when performance is good, red when it isn't. The number itself always reflects the straight math.
• Consistent with KPI cards. Tables now follow the same logic already used in KPI cards, so you get the same result everywhere.

🔄 What changed and why

Previously, unfavorable variables (like Cost of Sales) had their variance sign inverted: if you spent $120K against a $100K budget, the table showed −$20K in red. The intention was to signal "bad," but the negative sign was confusing because costs actually went up, not down.

Now, that same scenario shows +$20K in red: you spent $20K more than planned. The red still tells you it's bad, and the number tells you by how much. 

⚠️ Good to know

This change applies automatically to all existing tables. If you have any questions or concerns, reach out to your Abacum point of contact and we'll be happy to help.