0

Strange Math?

I created a formula to multiple a currency number field by a percentage number field. In this case the results should be 30 since $60 * 50% = $30. Ninox shows the result as $3000. That's not right. Is there a way to make this formula right as is without making some correcting math?

Screen Shot 2020-05-17 at 4.56.37 PM

2 replies

null
    • Nick
    • 3 yrs ago
    • Reported - view

    Your formula has to be:

    'Total Prize Pool' * '1st Place %' / 100

    • Mr_K
    • 3 yrs ago
    • Reported - view

    Obviously Ninox does not see %, it must only see the number, and it adds the % for our visusal benefit. Thanks for the formula NIck. I had already added / 100 to my formulas to correct the incorrect (in my mind) Nonix calculation.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 606Views