This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Trying to accomplish this simple formula but it results in an error???Using a Single Select Field and a Currency Field.{Toe Kick LI} * {Toe Kick Cost Per LI} Thanks in advanced for your assistance!
In the MP IMU% field I have this formula:
IF({MP ICOGS},SUM({MP IGP} / {MP ICOGS}))
My question is how do I change my formula to return a value in the MP IMU% field that is not a negative percentage? The true answer is 281.34% - I’m beyond stumped?...
I have expense fields set to ‘Allow Negative Numbers’. It would be really helpful to just enter 5.24 and have that field make it a negative number. I have a ton of fields I need to manually enter the currency for and trying to remember to add the m...
Is this even possible? I’ve watched a ton of automation tutorials and can’t find an answer.
From the Transaction Type: Order >Item ID field I would like to add this ID # to the Transaction Type: Shipping label >Item ID
And pretty much do the same th...
I clicked the link but the video only demonstrates adding one record. I am a visual learner is there a video that demonstrates a user filling it out and creating multiple records in one form? Maybe I have misunderstood - I need a single form that c...
Many thanks to @W_Vann_Hall and his demonstration base for Pretty Print - for an answer!DATETIME_FORMAT({Date of Trip}, 'YYYY-MM-DD')&"\nTrip Total: "& IF(LEFT({Sourcing Trip Total}&'',1,1)='-','-','')&'$'&IF(ABS(VALUE({Sourcing Trip Total}&''))>=100...
ScottWorld:
miniExtensions Form to Edit and Create Airtable Records
It’s a shame Airtable wants me to spend $39 a month with another company so I can use a form to update existing data in my free Airtable. I love Airtable but their inability ...
@augmented Thank you!
IF({MP ICOGS}, ABS({MP IGP}/{MP ICOGS}))
This worked!
COGS are actually expenses therefore they are entered as a negative number. All the income fields are entered as positive currency. Excel makes this easy but not so much ...
