The only difference in these formulas is that the second allows for the union between 3 different alternate states (Risk 1, 2,3) and the current state ($). I can verify that all states have nothing selected. This is the returned values:
Why does the second sum (the one with the alternates states) not return the value to the same precision as the first SUM?
I still dont understand why the same calculation just introducing alternate states causes the calculation to be different but I was figuring I would need to introduce a round() function to resolve my issue. Thanks for confirming.