Hi, I process credit cards. The gross value is column oritotal. I create the formula oritotal*0.035. That is fine. Now if I want to subtract the value of oritotal by oritotal*.0.035 (formula1), how do I display the net result in a column labeled Net?
If I understood you correctly - you'd like to create another formula column, and then subtract the original value from the first formula column, correct? If this is true, like our documentation says:
One formula column cannot be used in another. This limitation can be avoided by using nested calculations.
So, in order to do this, you would have to create a new formula column with this formula in it:
Hi, I process credit cards. The gross value is column oritotal. I create the formula oritotal*0.035. That is fine. Now if I want to subtract the value of oritotal by oritotal*.0.035 (formula1), how do I display the net result in a column labeled Net?
Thanks,
Dinh
Hello Dinh.
Thank you for your purchase.
If I understood you correctly - you'd like to create another formula column, and then subtract the original value from the first formula column, correct? If this is true, like our documentation says:
So, in order to do this, you would have to create a new formula column with this formula in it:
oritotal-(oritotal*0.035)
Best regards.
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