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

[Warang_L]

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

[RezaRaoofi]

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_L]

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

[RezaRaoofi]

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_L]

@RezaRaoofi

So the column type will

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

[RezaRaoofi]

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_L]

@RezaRaoofi Thank you so much.

[RezaRaoofi]

@Warang_L you’re welcome!