02-05-2018 07:12 AM
This formula ( in a calculated field )
([Client Confidence] + [Incumbent] + [Inter Personal Relationship] + [Level Of Competition] + [Pain Point] + [Past Client] + [Quality of Proposal] + [Will It happen] )
calculates a value of 30 ( exactly as it should based on the input )
This formula ,
(([Client Confidence] + [Incumbent] + [Inter Personal Relationship] + [Level Of Competition] + [Pain Point] + [Past Client] + [Quality of Proposal] + [Will It happen] )/ 40 )
Should calculate a value of .75 ( which it does not do ) the only difference is the / 40 and the brackets. I made sure the field is a decimal.
I checked the validity its ok, It tried with and without brackets
What did I do wrong in the formula
02-06-2018 03:11 AM
02-06-2018 05:54 AM - edited 02-06-2018 05:55 AM
Hello Jon and thanks for the reply
The fields have a maximum value of 5 and as such the total of all fields ( there are 8 ) is 40. The second order of operation is to take the 40 and divide it by 40 which returns a decimal value somewhere between 0 an 1. In the example provided the first order of operations is working correctly and in this case adding up to 31. The second order of operations where we divide ( sum operation 1 ) / 40 is not working.
I have tried with and without brackets .
The three " success " calculated fields are attempts with and without brackets .
02-06-2018 06:51 AM
02-06-2018 06:56 AM
0.00
02-06-2018 07:51 AM - edited 02-06-2018 08:02 AM
@JonTaylor wrote:
([Client Confidence] + [Incumbent] + [Inter Personal Relationship] + [Level Of Competition] + [Pain Point] + [Past Client] + [Quality of Proposal] + [Will It happen] )/ 40
I would agree.
That is how i would write this formula
02-06-2018 08:40 AM
02-06-2018 08:47 AM - edited 02-06-2018 08:48 AM
Thanks Jon, Perhaps I'm not explaining this correctly. There is no problem with the SUM portion of the equation. It executes correctly regardless of the number of fields. The problem is taking the sum # / 40 that isn't working. Is it possible that nested equations simply don't work in ACT!.
02-06-2018 09:13 AM