Custom Formula - write your own is being normalized

[Stina Hill]

I'm trying to write a custom formula and using the Write Your Own type to get my information but its normalizing on me. Is there a way to use this function without the normalization? What am I missing?

Thanks!

[Tanguy Crusson]

@Stina Hill could you please share a screenshot? I just tried and couldn't reproduce:

[Stina Hill]

Here are the inputs:

And here is the formula:

[Tanguy Crusson]

Are you sure you're editing the right field?

Is that the formula you see if you:

• hover over the "fx Impact" field name in the header of the list view
• click on it
• click "Edit field"

?

At first glance it looks like a totally different formula (if it normalizes something it isn't that formula). So I'm thinking either the system's getting the formula definition mixed up between fields, or you have 2 fields with similar names and you're editing the other one?

[Stina Hill]

Here's the hover (it is the same as when I open the field and edit):

I do have the same named fields in a different Discovery project, and created new fields in this project because I didn't see a way to interact with the same field across multiple projects. 

[Stina Hill]

I tried updating the fields in the other project to be unique. No change, I am still getting normalization when I want to see the actual numerical output of the formula.

[Stina Hill]

I'm wondering if this is because I created the fields as "Select" with a number as the input and it doesn't understand that? It seems to work as I want when the field is only a number value.

[Tanguy Crusson]

ooooooh my bad I had completely missed that. Yes, that would be the problem. Basically every field value for select fields would be "1" - so it's not normalizing, the only number that is not "1" is the value of "reach"

Here's how to fix that:

• Open each select field configuration
• Click on "Add weighting" > number
• For each field value, provide a weight corresponding to its label (e.g. "8")

That should do the trick