Is it possible to use the Mathematic Number s...

(Warang) #1

Is it possible to use the Mathematic Number such as a power likes " 5 squared" or “5 cubed” or “5 to the fourth power”? Thanks

(Reza Raoofi) #2

Use POWER() function; here is the details from help center:

Power(numericX, numericY) returns a decimal that raises numericX to the power of numericY. For example, Power(4, 2) = 16. Power(16, 0.5) = 4.

Check out this link for more Math expressions: https://intercom.help/appsheet/expressions/expression-types/math-expressions

(Warang) #3

@RezaRaoofi Thanks, more question how can I show the Power number format on the app?

(Reza Raoofi) #4

If you mean something like 2.3E6, or 2^4, there isn’t any straight forward formatting you could use; I would just put pieces together using CONCATENATE() function, or its equivalent operator which is & in syntax like this:

CONCATENATE(“text1”,"^",“text2”) or “text1” & “^” & “text2”

(Warang) #5

@RezaRaoofi

So the column type will

turn to text and the app could not use the compare expression. am I right?

(Reza Raoofi) #6

I would use 2 columns; one numeric for using POWER() function, comparing expressions, and storing the number, etc., and a second column that could be Virtual Column for display purposes which would contain CONCATENATE function to build the particular format you are looking for.

(Warang) #7

@RezaRaoofi Thank you so much.

(Reza Raoofi) #8

@Warang_L you’re welcome!