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!
@Stina Hill could you please share a screenshot? I just tried and couldn't reproduce:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you sure you're editing the right field?
Is that the formula you see if you:
?
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
That should do the trick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.