Excel formulas easily used in Caspio?

[roattw]

Need to convert an Excel based form with calculations to Caspio.  Will straight Excel formulas work or will it need lots of tweaking of conversion to to JS or SQL?

Thanks!

[ChrisCarlson]

roattw,

Excel formulas will not work directly in Caspio. You can find a list of Caspio formulas below:

https://howto.caspio.com/function-reference/

 

[roattw]

Thanks for the reply.  I think I got lucky.  They all seemed to work since fairly basic.  Although I cant get the Round() function to work without a syntax error.

[directrix]

Hello @roattw,

If you can give the exact formula you're trying to use the Round() function with, maybe we can help you with that.

[roattw]

4 hours ago, directrix said:

Hello @roattw,

If you can give the exact formula you're trying to use the Round() function with, maybe we can help you with that.

Thanks for the offer.  The localization decimal place setting didnt work either.  Here is the formula I need to round to no decimals.

 (4*[@field:Burn_Amnt]*[@field:Weight])+(1500*[@field:BSA])

 

[DefinitelyNot31337]

Hi @roattw,

 

I replied on your other post. It seemed to work on my account when I tried to replicate it.

You might have missed a few opening/closing parenthesis and/or misplaced them. Formulas can get really confusing especially when it's already long.

 

Cheers,

DN31337

 

[roattw]

I did have a missing bracket - darn.  Better.  But the Localization setting of 2 decimals does not seem to have an effect.