Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Decimal places being removed in formula + 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

Topic Labels: Automations
364 9
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I am using this formula and it isn’t implementing the decimal places from my {Refill / lowest price} column, which in itself is set to 2 decimal places:

"Lowest cost per " & {Unit} & " based on: " & “£” & {Refill / lowest price} & " for "& {Lowest cost option}

It is bringing back things like the following;

“Lowest cost per wash based on: £5.3 for 24 capsules (fragranced)”

If I go to formatting it gives me “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.”

But is there any way to ensure it ‘pulls’ the number with both decimal places?

Thank you!

9 Replies 9

Hi Cassy, what field type is the {Refill / lowest price} ?

Hey Rupert!

It’s a # Number field with precision set to Decimal 1.00 precision.

Thanks for your help!

I’m not able to replicate this, for me it’s showing correctly. Can you send a screenshot of the formulas and the fields?

Sure :slightly_smiling_face:

image

image

Thanks again!

It seems to just be for the prices ending in 0 i.e:

£5.30 > £5.3
£5.80 > £5.8

Legend! Thank you so much!

I formatted the number as suggested in that post above, and then used that in the formula and it’s worked perfectly!

Just realised something…

The formula provided before in that post actually removes the .00 for rounded numbers under the value of £10. i.e £5.00 becomes £50

IF(Number, "£" & Number & IF(FIND(".", Number & "") = LEN(Number & "") - 1, "0"))

image

Is there something I can do to tweak the formula?

Really appreciate your help with this!

Side note: here is a clearer view of the formula result:

image