Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Get error on float values subtraction only on folmula columns
Hello Cezar Fernando.
Thank you for reaching out to us.
I wasn't able to replicate this issue locally, or I didn't understand it completely.
Can you please record your screen and show me the issue, so I can check it out?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
The problem occurs in complex or simple formulas where I have a float column referenced more than once involving subtraction. The simplest possible example is this: newcolumn1-newcolumn1 returns "Unable to calculate". This example is very basic but the problem occurs in more complex formulas. The intriguing thing is that it only happens involving subtraction and always when the same column is referenced in the formula.
Another example:
(vparc*totalparc)-(vparc*nparc) = Unable to calculate
vparc: float
totalparc: integer
nparc: integer
Attached files: screenshot-antoniorollemberg.com-2023.12.20-19_58_49.png
Hi again.
I can't replicate this issue. Here's the first (basic) example:
The expected result is 0, of course, and that works fine.
Then, I used your screenshot as an example, and created this formula:
It shows the preview, and it calculates the data correctly:
The first one is a float column:
While the other two are integers:
Is this error only appearing in the preview or does the formula column not display any values either? How big is the table? Which version of the plugin are you using?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Very strange. The formula column not display any values (Unable to calculate). I am using European format 10.6578,78
I tested on small datasets, 5 lines only
Using version 6.0
Already figured out. Was the php version. Upgrade to php 8. Solved. Thanks
Thank you for letting me know, Cezar Fernando.
Please feel free to reach out to us if you have any further questions or concerns!
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables