Skip to main content

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.



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?

Reply


Terms & Conditions