The "Benefit Variance" field in Benefit Plans incorrectly calculates the Variance as "Benefit - Realized Benefit", when the calculation should be "Realized Benefit - Benefit". This misrepresents the variation in benefit, especially in a scenario where the "Realized Benefit" is greater than the "Planned Benefit". For example, if the "Realized Benefit" is $10,000, while the "Planned Benefit" was $5,000, then the "Benefit Variance" would be calculated as -$5,000, and represented in Red.
<Please see attached file for image>
This is caused by a defect - DE32391.
Disposition: No plans to fix at this time.
The following can be used as a workaround:
1. Create a custom attribute on the "Benefit Plan Detail" object, say, "Benefit Variance Custom"
2. Display this custom attribute in the "Benefit Plan Detail - List" view
3. Take away the OOTB, "Benefit Variance" attribute from the above mentioned view
4. This will provide the users the ability to manually enter the Benefit variance
5. Further, a process can be developed to make the variance calculation, and lock the field for user input.