Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

How to add conditional sum calculated field?

liangyi2012 asked on July 26, 2018

For example, https://jsfiddle.net/8ho41k0g/1/.
Say I wish to calculate the “Top Category” as per defined. However, wish to exclude color “green”. So green is always 0 for the Top category. Is this possible?

2 answers

Public
Ian Sadovy Flexmonster July 26, 2018

Hello,
 
Thank you for the question.
Actually, there is no option to write such condition in calculated value formula.
But, you can filter the dataset to exclude the “green” as follows: https://jsfiddle.net/flexmonster/x2t9ac3e/
Also, you can use customizeCell to replace the cell value for “green” row (a bit hacky solution): https://jsfiddle.net/flexmonster/vup89fq5/
Hope it helps.
 
Regards,
Ian

Public
liangyi2012 July 30, 2018

customizecell looks good. Thanks for the answer.

Please login or Register to Submit Answer