nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

All comments

Tanguy Crusson

@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

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):

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.