Hello-

I have a formula field that multiples values from two other rows. It functions properly when multiplying values without decimal points, e.g., 1, 2, 3, 4, etc. But fails to account for values with decimal points, e.g., 1.5, 2.5, 3.5. The odd thing is that for those values (the ones with decimal points), it actually accounts for the numeric portion of the values without the decimal value. Specifically, for 1.5 or 2.5, it will multiply based on 1 or 2, respectively. It ignores that there is a .5 tacked on as wellâ€¦ Here is the formula:

IF({Mins}=15,".5",IF({Mins}=30,â€ś1â€ť,IF({Mins}=45,â€ś1.5â€ť,IF({Mins}=60,â€ś2â€ť,IF({Mins}=75,â€ś2.5â€ť,IF({Mins}=90,â€ś3â€ť,IF({Mins}=105,â€ś3.5â€ť,IF({Mins}=120,â€ś4â€ť," "))))))))

Not sure if this is helpful, but when I click on the â€śformattingâ€ť tab within the field, here is the response:

â€śYour result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.â€ť

Thanks in advance!