I’m trying to just double the value of a field in another field. I have one field called “costs” and another field called “goal” that I want to double to let me know how much profit I should try to make from an event.
I’ve tried:
{Total Costs} * 2
Also putting the 2 in parenthesis, leaving out the spaces, etc. Nothing seems to work.
Best answer by Kamille_Parks11
Is {Total Costs} actually a number?
+29Welcome to the Airtable community!
What is the field type of the {Total Costs} field?
Do you want to double {Costs} or {Total Costs} or {Goal}? Can you post a screen capture?
Sometimes values that look like numbers to a human aren’t actually numbers according to a computer.
+21@Jacob_Halton Have you been able to figure this out yet? If not, please answer the questions asked above so that we can better assist you.
I’m not sure what happened but it’s working now. I think maybe that the data in {Total Costs} wasn’t set up properly because now that formula does multiply the total costs field by 2
Welcome to the Airtable community!
What is the field type of the {Total Costs} field?
Do you want to double {Costs} or {Total Costs} or {Goal}? Can you post a screen capture?
Sometimes values that look like numbers to a human aren’t actually numbers according to a computer.
I think you might be right in thinking it wasn’t a number. It’s working now after I messed around with a bunch of things and that might be why it didn’t work before.
Thanks!
Is {Total Costs} actually a number?
Yes I think I might’ve had this set incorrectly. I messed around with a bunch of things and now it’s working so it probably wasn’t a number before
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
