Help with formula for compounding interest

(@aff1398)

Thank you! Unfortunately I’ve tried that equation, in my case its:

fieldname22*POW(1+fieldname26/12, 12*fieldname29)

where 22 is initial balance, 26 is interest % and 29 is years. The result now gives me numbers far beyond human comprehension :/

I can provide you with a link to the page but as it’s developmental at this stage should remain confidential so I can’t post it publicly. Is there a way I can PM/DM you a link?

Plugin Author

(@codepeople)

Hello @aff1398

If fieldname26 is a number field whose “Number type” attribute is not percent, you must edit the equation as follows:

fieldname22*POW(1+(fieldname26/100)/12, 12*fieldname29)

Regarding the design conflict, for security reasons and the policies of this forum, you cannot share your credentials, and we cannot accept them.

If the slider control is fine on form preview, but the design problem happens on the final page, the issue must be related to the styles loaded by the theme active on your website or third-party plugins. To discard a theme conflict, you can try a different WordPress theme.

Best regards.

Thread Starter

(@aff1398)

That formula is amazing! 100% accurate very many thank you’s for that 🙂 Now just to work out how to set to only show two decimal places 🤔

The odd thing is that I’m not using any themes. I am building with Elementor but I am making each page from scratch, basically the default blank canvas rather than selecting any specific themes to modify.

I am using template 13 on CFF and that’s the one that’s just recently decided to do the weird thing on the front end. Using a different CFF template resolves the issue but then doesn’t look like what I need :/

Thread Starter

(@aff1398)

Turns out I spoke too soon. It was only in preview mode that it appeared the other CFF templates were displaying properly but it turns out when saved and published every single slider on any template will have a white circle in the same spot on the left hand of the slider bar that remains static underneath the moving bit.

Plugin Author

(@codepeople)

Hello @aff1398

To display the result with two decimal places, you should use the PREC operation as the outermost operation in the equation. PREC(X, Y) rounds the number X with Y decimals.

So, if you need the equation result with two decimal places, you should edit it as follows:

PREC(fieldname22*POW(1+(fieldname26/100)/12, 12*fieldname29), 2)

If your form is not yet public, please send me the site information. Go to the menu option “Tools > Site Health > Information” and click on the button “Copy site information to clipboard.”.

Best regards.

Thread Starter

(@aff1398)

Thank you. That PREC allowed me to make some other changes elsewhere which was very helpful 🙂

Site information as follows:


### wp-core ###

version: 6.1.1
site_language: en_US
user_language: en_US
timezone: +11:00
permalink: /%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 1
default_comment_status: open
environment_type: production
user_count: 3
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /var/www
wordpress_size: 1.04 GB (1119367869 bytes)
uploads_path: /var/www/wp-content/uploads
uploads_size: 70.25 MB (73662317 bytes)
themes_path: /var/www/wp-content/themes
themes_size: 14.35 MB (15045593 bytes)
plugins_path: /var/www/wp-content/plugins
plugins_size: 158.26 MB (165944077 bytes)
database_size: 56.44 MB (59179008 bytes)
total_size: 1.33 GB (1433198864 bytes)

### wp-dropins (3) ###

db-error.php: true
db.php: true
object-cache.php: true

### wp-active-theme ###

name: Hello Elementor (hello-elementor)
version: 2.6.1
author: Elementor Team
author_website: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
parent_theme: none
theme_features: core-block-patterns, widgets-block-editor, menus, post-thumbnails, automatic-feed-links, title-tag, html5, custom-logo, editor-style, align-wide, woocommerce, wc-product-gallery-zoom, wc-product-gallery-lightbox, wc-product-gallery-slider
theme_path: /var/www/wp-content/themes/hello-elementor
auto_update: Enabled

### wp-themes-inactive (4) ###

Twenty Twenty: version: 2.1, author: the WordPress team, Auto-updates enabled
Twenty Twenty-One: version: 1.7, author: the WordPress team, Auto-updates enabled
Twenty Twenty-Three: version: 1.0, author: the WordPress team, Auto-updates disabled
Twenty Twenty-Two: version: 1.3, author: the WordPress team, Auto-updates enabled

### wp-mu-plugins (3) ###

object-cache.php: author: (undefined), version: (undefined)
System Plugin: author: (undefined), version: 4.53.0
WP REST Cache - Must-Use Plugin: version: 2021.3.0, author: Richard Korthuis - Acato

### wp-plugins-active (15) ###

All-in-One WP Migration: version: 7.68, author: ServMask, Auto-updates enabled
All-in-One WP Migration Unlimited Extension: version: 2.47, author: ServMask, Auto-updates enabled
Calculated Fields Form: version: 1.1.128, author: CodePeople, Auto-updates enabled
Depicter: version: 1.3.8, author: Averta, Auto-updates enabled
Disable XML-RPC: version: 1.0.1, author: Philip Erb, Auto-updates enabled
Elementor: version: 3.8.1, author: Elementor.com, Auto-updates enabled
Essential Addons for Elementor: version: 5.4.2, author: WPDeveloper, Auto-updates enabled
Extensions For CF7: version: 2.0.8, author: HasThemes, Auto-updates enabled
Fluent Forms: version: 4.3.22, author: Contact Form - WPManageNinja LLC, Auto-updates enabled
Fluent Forms Pro Add On Pack: version: 4.3.21, author: Fluent Forms, Auto-updates enabled
Premium Addons for Elementor: version: 4.9.37, author: Leap13, Auto-updates enabled
Query Monitor: version: 3.10.1, author: John Blackbourn, Auto-updates enabled
WP Go Maps (formerly WP Google Maps): version: 9.0.14, author: WP Go Maps, Auto-updates enabled
WP Go Maps - Pro Add-on: version: 9.0.11, author: WP Google Maps (latest version: 9.0.13), Auto-updates disabled
WP REST Cache: version: 2022.2.2, author: Acato, Auto-updates enabled

### wp-plugins-inactive (9) ###

Akismet Anti-Spam: version: 5.0.1, author: Automattic, Auto-updates enabled
bunny.net: version: 1.0.8, author: bunny.net, Auto-updates enabled
Debug Bar: version: 1.1.3, author: wordpressdotorg, Auto-updates enabled
Everest Forms: version: 1.9.5, author: WPEverest (latest version: 1.9.6), Auto-updates enabled
Gravity Forms: version: 2.6.6, author: Gravity Forms, Auto-updates enabled
Smush: version: 3.12.3, author: WPMU DEV (latest version: 3.12.4), Auto-updates enabled
Sucuri Security - Auditing, Malware Scanner and Hardening: version: 1.8.35, author: Sucuri Inc., Auto-updates enabled
WP Debugging: version: 2.11.14, author: Andy Fragen, Auto-updates enabled
WP Fastest Cache: version: 1.0.8, author: Emre Vona, Auto-updates enabled

### wp-media ###

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1808
imagemagick_version: ImageMagick 7.1.0-16 Q16-HDRI x86_64 2021-11-21 https://imagemagick.org
imagick_version: 3.7.0
file_uploads: File uploads is turned off
post_max_size: 100M
upload_max_filesize: 100M
max_effective_size: 100 MB
max_file_uploads: 20
imagick_limits:
imagick::RESOURCETYPE_AREA: 2 TB
imagick::RESOURCETYPE_DISK: 9.2233720368548E+18
imagick::RESOURCETYPE_FILE: 196608
imagick::RESOURCETYPE_MAP: 2 TB
imagick::RESOURCETYPE_MEMORY: 1,008 GB
imagick::RESOURCETYPE_THREAD: 1
imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, ASHLAR, AVI, AVIF, AVS, BGR, BGRA, BGRO, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUBE, CUR, CUT, DATA, DCM, DCR, DCRAW, DCX, DDS, DFONT, DNG, DOT, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, FARBFELD, FAX, FF, FILE, FITS, FL32, FLV, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, GV, HALD, HDR, HEIC, HEIF, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, JNG, JNX, JPE, JPEG, JPG, JPS, JSON, K25, KDC, KERNEL, LABEL, M2V, M4V, MAC, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NRW, NULL, ORA, ORF, OTB, OTF, PAL, PALM, PAM, PANGO, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PHM, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGB565, RGBA, RGBO, RGF, RLA, RLE, RMF, RSVG, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TM2, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMV, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YAML, YCbCr, YCbCrA, YUV
gd_version: bundled (2.1.0 compatible)
gd_formats: GIF, JPEG, PNG, BMP
ghostscript_version: 9.55.0

### wp-server ###

server_architecture: Linux 5.4.206-200.el7.x86_64 x86_64
httpd_software: Apache
php_version: 8.0.22 64bit
php_sapi: cgi-fcgi
max_input_variables: 1000
time_limit: 300
memory_limit: 512M
max_input_time: 60
upload_max_filesize: 100M
php_post_max_size: 100M
curl_version: 7.80.0 OpenSSL/1.1.1q
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: true

### wp-database ###

extension: mysqli
server_version: 5.7.26-29-log
client_version: mysqlnd 8.0.22
max_allowed_packet: 16777216
max_connections: 1000

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /var/www/wp-content
WP_PLUGIN_DIR: /var/www/wp-content/plugins
WP_MEMORY_LIMIT: 512M
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: false
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Undefined
DB_CHARSET: utf8
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

Plugin Author

(@codepeople)

Hello @aff1398

I activated the “Elementor Hello” theme on my website, and the issue with the Slider is not happening. Please, let me know when your form be published to check the styles loaded by your page.

Best regards.

Thread Starter

(@aff1398)

https://afftester.com/88jahk47/

I’ve loaded it into the following page so you can see 🙂

Unusual hey

Plugin Author

(@codepeople)

Hello @aff1398

Thank you very much. I visited your webpage from desktop browsers and mobile devices, and the sliders have no ghosts icons.

Best regards.

This reply was modified 3 years, 6 months ago by Yui.
This reply was modified 3 years, 6 months ago by Alvaro Gómez.

Thread Starter

(@aff1398)

How perplexing.

I’ve just run it through Safari and it looks normal.

Running through Chrome shows the ghosting still.

On mobile it was always OK but desktop Chrome isn’t liking it since the recent WP update 🤔

Edit – seems I can edit this post but not the others. Can I respectfully ask that your screenshots and the link I posted be removed as I continue to progress this project. The earlier portion about the calculations could help others so I think they should remain but I don’t feel comfortable with the links/screenshots being viewable like that.

This reply was modified 3 years, 6 months ago by aff1398.

Plugin Author

(@codepeople)

Hello @aff1398

My desktop screenshot was taken using the Chrome browser. Please try again, but this time with the browser in incognito mode to make sure the problem is not caused by an extension installed in the browser.

Best regards.

Thread Starter

(@aff1398)

It’s not showing up in incognito mode so obviously something local on my machine.

Thank you for the help – can you please delete the link I posted along with your screen shots.

Plugin Author

(@codepeople)

Hello @aff1398

I’m sorry, there are no options in the forum to delete the screenshots or edit previous posts.

Best regards.

Thread Starter

(@aff1398)