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...
Hello! I’ve created a simple way to track time with clients using two forms.
Basically using their mobile phone:
The agent will complete the ‘Start Time’ form to record their start time with a client. When they are done they will complete the ‘End T...
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 ...
Thanks @ScottWorld - this is the very reason I’m trying the automation. But I’m doing something wrong…
I think I do not understand the logic of how to access the previous record correctly.
