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...
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...
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 ...
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...
@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?
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...
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...
