Maybe a problem in weighted formula
Below I have a calculated field with just one positive and one negative entry (for testing, the final one has more items).
The calculated field show the values 100, 50, 50. This is correct with the blue "impact" field and once I change the blue field, all is calculated fine.
However, in the negative part (red field) this is not working, and negative values seems ignored.
The two 50 numbers should be diffent based on the red values.
Am I doing something wrong here?
1 answer
1 accepted
By the way, this is the expected result in the formula (from documentation). Not so easy to guess, but my example has only two fields. It seems the denominator is failing to process the negative input field value.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.