Lauren_Prete - profile

Lauren_Prete · Mar 19, 2023

Hi Airtable Wizards, I have the following formula which is formatted in currency and occasionally returns a -$0.00 result, where to my untrained eye, I cannot see why. {PM: TOTAL BANK ALL EFTPOS}-{PM: TOTAL EFTPOS SALES}"PM: TOTAL BANK ALL EFTPOS" a...

Lauren_Prete · Aug 17, 2022

Hi all, Got a real brain teaser here (or at least one my brain can’t handle lol). I’m trying to calculate the ACTUAL DURATION - EXPECTED DURATION of ticket processing time for our team. The EXPECTED DURATION field is calculated: NO OF TICKETS(integer...

Lauren_Prete · Jul 17, 2022

Hi brains trust, Is someone able to assist with creating a duration formula that returns a “0:00” result when missing inputs? I need to track team processing time on a particular project and currently have the following formula inputted under column ...

Lauren_Prete · Apr 06, 2022

Hi all, This has become a bit of a brainteaser for me and was wondering if anyone much more proficient than I could have a crack! Trying to formulate a field to return COST PRICE as a NEG value when the following options are true: There is a value in...

Lauren_Prete · Apr 02, 2023

Thanks @TheTimeSavingCo! Worked a treat!

Lauren_Prete · Mar 22, 2023

@TheTimeSavingCo I certainly did not know that! Just tried the following and it's not liking my input/direction as my result is formulated in currency.ROUND({PM: TOTAL BANK ALL EFTPOS}-{PM: TOTAL EFTPOS SALES}, 0.00)Any ideas on a workaround here?

Lauren_Prete · Mar 20, 2023

Ah I see, thanks @TheTimeSavingCo! Unfortunately ROUND() rounds my output too much and I need to be aware of any discrepancy, no matter how large or small (e.g. 0.04 is rounded to 0.00). After having a look at those threads, this looks to be an endem...

Lauren_Prete · Aug 18, 2022

Ah, so it’s my understanding of decimal to time that needs work here :grinning_face_with_sweat: Thanks so much @ScottWorld, appreciate the help!

Lauren_Prete · Aug 18, 2022

LOL apologies @ScottWorld this was a typo. My 2nd formula does calculate as below and return the below result which remains inconsistent with the result retrieved in the 1st formula when calculating in minutes/decimals: NO OF TICKETS(integer)*330(sec...

User Statistics

User Activity

SUM formula returning negative currency values - why?

Time Formula/Calculation for Expected Output in Duration

Duration Formula When Missing Values

IF+AND Statement w Exclusion Conditions

Re: SUM formula returning negative currency values - why?

Re: SUM formula returning negative currency values - why?

Re: SUM formula returning negative currency values - why?

Re: Time Formula/Calculation for Expected Output in Duration

Re: Time Formula/Calculation for Expected Output in Duration