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
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?
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