28
Views
2
Comments
[Formula] Calculation Issue with a Formula
Question
formula
Service icon
Forge asset by Caio Santana Magalhães
Application Type
Service

I need to perform calculations with scientific formulas, and for some reason, the component is not returning the correct value if I enter the formula without converting a number in the formula to decimal.

The formula below should return the value 352.6, but it is returning the value 49.71890628608.

Formula: 10 ^ 1 * 10 ^ 9 * 10 ^ -8 * 3.526

I noticed that if I convert one of the "10" to decimal "10.0", it correctly returns the value.

Formula: 10.0 ^ 1 * 10 ^ 9 * 10 ^ -8 * 3.526 ... I get the value 352.6

Does anyone know if there is a way to solve this issue without formatting the number?

UserImage.jpg
Sneha Kumari

Hi @Maykell Ribeiro , can you try this way -->  (10 ^ (1 + 9 + -8 )* 3.526) . You can try adding up the powers .


UserImage.jpg
Craig Rodrigues

@Maykell Ribeiro Hello , 
Please find below the screenshot it seems to fine if you a local variable.


Kind regards,
Craig

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.