Help

Re: Field Reference Formula Error

778 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Superhost
4 - Data Explorer
4 - Data Explorer

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.



1 Reply 1

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?