Skip to main content

Field Reference Formula Error

  • February 7, 2023
  • 1 reply
  • 34 views
S
Forum|alt.badge.img

I have a formula that works when a set decimal is entered but not when the decimal is inputted from a field reference. 

The formula that works (with manual decimal at the end): 

IF({Custom MSH Fee} > 0, {Custom MSH Fee}, ({Total Booking Price}+{Channel Booking Fee Amount (inc manual fees)})*0.1)

The formula that doesn't work (with decimal from Field Reference)
 
IF({Custom MSH Fee} > 0,{Custom MSH Fee},({Total Booking Price}+{Channel Booking Fee Amount (inc manual fees)})*{MSH Commission Decimal})

What am I doing wrong here? I want to be able to vary the decimal based on the data entered in the reference field. Thanks all.



This topic has been closed for replies.

1 reply

TheTimeSavingCo
Forum|alt.badge.img+32

Hmm, is the field type of `MSH Commission Decimal` a number?  If not, perhaps you could try:

IF({Custom MSH Fee} > 0,{Custom MSH Fee},({Total Booking Price}+{Channel Booking Fee Amount (inc manual fees)})*VALUE({MSH Commission Decimal}))

`VALUE()` converts text into a number where possible, and might solve your problem here?

If not, could you perhaps share a screenshot of your table with the relevant fields please?

Adam, Airtable Consultant - https://thetimesaving.company
Terms & ConditionsAccessibility statement