Formatting Issue with Lookup Field: Incorrect Decimal Values in Booking Calculations

[Cesco]

I have a database with two tables:

• “Referrers”, that contains two fields:

  • Name (Single-line Text)
  • Price (Number)

• “Bookings”, that contains six fields:

  • Date (Date and time)
  • People (Number)
  • Name (Single-line text)
  • Referrer (Link to table “Referrers”)
  • Referrer Price (Link to the field “price” of the linked table “Referrers”)
  • Amount To Pay (Formula: “field(‘People’) * field(‘Referrer Price’)” )

All the number fields and the formula are set this way:

• 2 Decimal places
• Prefix: None
• Suffix: €
• Thousand and decimal separator: Period, Comma (1.000.000,00)

The referrer price (a lookup field that takes the field “Price” from the linked table “referrers”) reports 600,00€ instead of 6,00€. Therefore, when Baserow calculates the amount to pay, with the formula field('People') * field('Referrer Price') the result is wrong: 2.400,00€ instead of 24,00€

Is this a bug or am I doing something wrong?

[olgatrykush]

Hey @Cesco, I’ve replicated the issue and will check with the development team on what is going wrong here. Thanks for reporting this!

[olgatrykush]

Hi @Cesco, we’ve confirmed this is a bug. You can track the fix here: Issue with frontend when looking up formatted number fields (#3332) · Issues · Baserow / baserow · GitLab. We apologize for the inconvenience.