HELP IN FORMULA

Hello @yogeekeye

There are some issues in your equation:

* The POW operation requires two parameters.
* The “^” operator cannot be translated into a multiplication.
* The number of parentheses in your equation is incorrect.

The correct equation would be:

POW(fieldname3/fieldname2, 1/fieldname4)-1

Best regards.

Thanks for the quick help, the answer is coming somehow correct i mean if i put field2 =5000
field 3= 50000
field 4= 2 years
the answer coming is 2.1622, however the correct one is 216.23

Hello @yogeekeye

That’s not true, you can evaluate it manually if you want. The result of the operation:

[(Ending value/Beginning Value)^(1/N)]-1

with the recommended values:

[(50000/5000)^(1/2)]-1 = 2.1622776601683795

Please, look at the screenshot with the same operation evaluated in Excel:

Best regards.

Thanks your help your forum is out of world, i have not seen such kind of help given by any other, i have figured it out the above equation, you deserve more than 5 star….

Sorry to bother you again just have another query about rounding up the answer , as in the above example the answer id coming as 2.16227766, however i only want 2.16 and hide other numbers that would be great.
thanks

Hello @yogeekeye

Yes, of course, you should use the PREC operation as the outermost operation in the equation. For example, if your equation is fieldname1+fieldname2 and you want the result with two decimal places, it should be edited as follows: PREC(fieldname1+fieldname2, 2)

More information in the following post of the plugin’s blog:

https://cff.dwbooster.com/blog/2020/09/20/rounding-numbers/

Best regards.

Thank you so much for your help…..