Hi all, I'm trying to use two values to calculate a field on a form. When I use code below in the AfterUpdate in the fields KPI1 and KPI2
it doesn't calculate properly, for example when the values above are 5, 5 and 5, I should get 100%, however, I get 5.5, when I use values 4,4 and 5, I should get 80%, but I get 4.4. When I use the above statement with SUM in front, I get SUB or FUNCTION not defined error. I've tried using the control source of the field and that doesn't display anything. Thanks in advance for any help provided.Code:Me.Score = (Me.KPI1.Value + Me.KPI2.Value) / (Me.TouchesTotal.Value * 2)