New Formula - Convert String to Double
Hi everyone. I'm trying to create a basic New Formula in an insight where I take a double data type and multiply it by a string data type. Since this formula won't work, I'm curious if I can use a function to convert the string to a double within the formula itself? Changing the data type in the underlying schema isn't an option. Any suggestions?
hi Michelle Fox yes, it is valid to do it in the formula. Wrap your string value with the double() function. You may need to add additional logic if there are non-numeric values in your string field.