Get Free Trial

Setting up a formula

Blitz asked on May 27, 2021

Good afternoon, you need to make the formula read the product of the columns, and in the end output the sum of the rows received, and not the same product.
The screenshot shows that the product of the columns is calculated correctly, but in the Total field, the product is also calculated by entering a total of 82,800, but you need to enter the sum of the rows equal to 27,390.
Can this be implemented?


1 answer

Vera Didenko Vera Didenko Flexmonster May 27, 2021

Thank you for writing to us.
We would like to kindly explain that using a different formula for calculating the Grand Total is not supported at the moment. Still, this feature request is in our backlog, and we will inform you in case of any changes.
If desired, you can hide specific Grand Total cell values with the customizeCell hook. Here is a JSFiddle example for illustration:
Please let us know if other questions arise.
Kind regards,

This question is now closed