Get KoolPHP UI with 30% OFF!

Adding Arithmetic Operators

I love the flexibility of KoolPivotTable, however I really need to add a variance $ and % from prior year and current year Does anyone have an suggestions on how to execute this? Does KoolPHPsuite have the capabilities to perform these on the fly? Any help is appreciated! Thanks
Posted Dec 20, 2016 Kool
Carlos Eduardo
No one answered the topic?
Posted Jan 17, 2017 Kool
Hi Carlos,
We have answered this question in a ticket support to Hallie. The answer depends on the nature of her data structure and query so if you have a similar problem, please let us know more detail for us to help you. Thanks!
Posted Jan 18, 2017 Kool
Basically, you just need to build SQL query that get the variance that you want. The Pivot table will summarize the variance. For example, if you have 2 column Revenue and Expense and you want to get the profit, you will do:
SELECT revenue,expense, (revenue-expense) AS profit FROM table
Posted Jan 18, 2017 Kool