Solved

Do Calculation Issues with Multiply

  • 24 April 2023
  • 2 replies
  • 108 views

Badge +2

Hi all,

I’m using the Do Calculation action to calculate % on a value and store it in a number variable.  I’m having 2 issues:

  1.  I need to multiply by 0.05 (5%).  The interface won’t let me enter 0.05?  I can enter 0.5 but as soon as I enter 0.0...it keeps blanking out my second zero?
  2. Are only 2 decimal places is supported?  I’m trying 0.4975.

 

Thanks for any help!

Troy

icon

Best answer by Garrett 24 April 2023, 16:20

View original

2 replies

Userlevel 6
Badge +16

Hi @troylyon 

 

Here is a workaround. To get 0.05 (5%). Create a variable then perform Do Calc (5 / 100)

 

Using Log to History

 

You can use the same method to get numbers with more decimal point eg 0.4975 (4975 / 10,000)

Badge +2

Thanks Garrett, yep, that’s a great work around.  I’ll either do this, or just setup a list with the percentage rates and do a list lookup on the rate column in the calculation.

 

Cheers,

Troy

Reply