Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 14, 2021 12:57 PM
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.
Solved! Go to Solution.
Aug 14, 2021 02:22 PM
Aug 14, 2021 02:22 PM
Is {Total Costs}
actually a number?
Aug 15, 2021 05:49 AM
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.
Aug 21, 2021 09:16 AM
@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.
Aug 30, 2021 06:33 AM
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
Aug 30, 2021 06:33 AM
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!
Aug 30, 2021 06:34 AM
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