Variable calcuation - decimal issue

cyndi
cyndi Community Member Posts: 5
Hmm, I feel really dirty suggesting this, but you could multiply the user-entered data by 100 (or more).  Then, divide your final result by whatever power of 10 you end up with at the end (10,000 for squared, etc.). 

 

As an interesting aside, I did an experiment with the Form Entry.  You can set an action for On Select/Change to modify that exact variable with a Multiply Variable By 100.  As you change the information in the entry box, the variable automatically updates to be 100 * whatever is entered in the form box.  I had never tried that before.  Since I just now discovered it, I don't know of the pitfalls, but it looks pretty solid so far.

 

Just some suggestions.  Rounding can be a pain. Just ask Excel.

 

Kevin