Help

Fields multiply

Topic Labels: Formulas
Solved
Jump to Solution
520 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Julien_Etoke
6 - Interface Innovator
6 - Interface Innovator

Hello community,

I'm trying to multiply two fields but I get an error message.

Cell 1 : a currency field manually filled like "€100"
Cell 2 : a formula field with number like "10,1"

I want to multiply "10,1" by "€100"

Formula : (cell1) * (cell2)

Do you know why i'm getting an error message ?

Kindly

1 Solution

Accepted Solutions
AirOps
7 - App Architect
7 - App Architect

Hi Julien, 

My inclination is that your formula field with a number like "10,1" is being perceived as a string in you new formula. I would check the formatting of your formula containing values with commas to double check it is being perceived as number value. 

If you want a quick fix you can try to encapsulate cell2 by the VALUE( ) function which should recognize 10,1 correctly. Your formula would then become: (cell1)*VALUE(cell2)

Hope this helps!

See Solution in Thread

2 Replies 2
AirOps
7 - App Architect
7 - App Architect

Hi Julien, 

My inclination is that your formula field with a number like "10,1" is being perceived as a string in you new formula. I would check the formatting of your formula containing values with commas to double check it is being perceived as number value. 

If you want a quick fix you can try to encapsulate cell2 by the VALUE( ) function which should recognize 10,1 correctly. Your formula would then become: (cell1)*VALUE(cell2)

Hope this helps!

To add on to what Cherry said, you may need to modify your original formula to use periods instead of commas.

Alternatively, you could use the following formula as well:

VALUE(
  SUBSTITUTE(
    {Cell 1},
    ",",
    "."
  )
)

Screenshot 2023-02-24 at 4.30.52 PM.png