asked 2 days ago
Hi,
I want to use calculated fields in my reports
1. I want to calculate variance of deposits e.g. Current Year vs Prior or current quarter vs prior quarter or over product a product b In fact column A and Column B may have different hierarchies such as year, date, product branch etc.
2. I am show list of deposits by branch and products and I want show % of deposits with respect to grand total shown at the bottom of the column
Regards,
Gokul
⋅ 22 hours ago
Hello, Gokul!
Thank you for writing to us.
For displaying variances between different columns, we recommend using the differenceofrow or differenceofcolumn aggregations. They calculate. In case of differenceofrow cells show the difference between two adjacent cells of the same level from left to right, with differenceofcolumn the difference is calculated between adjacent cells from top to bottom. You can find usage examples for these cases below:
To show the percentage of grand total, use the percentofcolumn, which calculates the percentage of each value relative to each separate total of the column at the bottom: https://jsfiddle.net/flexmonster/2y5m63uf/
Also, Flexmonster has a percent aggregation, showing percentages relative to the grand total of all values at the bottom right: https://jsfiddle.net/flexmonster/k3b10qjx/
Please let us know if these aggregations are what you were looking for.
Best Regards,
Maksym
