Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Custom Formula - write your own is being normalized

Stina Hill June 16, 2023

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!

1 answer

Suggest an answer

Log in or Sign up to answer
1 vote
Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 16, 2023

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

Screenshot 2023-06-16 at 17.23.34.png

Stina Hill June 16, 2023

Here are the inputs:

Inputs.png

And here is the formula:

Expression.png

Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 16, 2023

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 June 16, 2023

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

Hover over formula.png

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 June 16, 2023

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 June 16, 2023

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
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
June 19, 2023

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

Like # people like this
TAGS
AUG Leaders

Atlassian Community Events