I have a percentage formula that works perfectly, except when both columns are empty/the values are 0. When both Published and Rejected are 0, I want the column to be blank rather than show an error. Here’s the formula that works: CONCATENATE(ROUNDUP((((DIVIDE({Published#Count},SUM({Published#Count…

Hi Meagan, The problem with your formula (and why you’re getting errors when the values are 0) is that you’re dividing {Published#Count} by the sum of {Published#Count} and {Rejected#Count}. When both are at 0, the sum is 0, therefore you’re dividing by 0 which is an illegal operation and you get t…

Calculate Percentage, or Leave Blank if Both Column Counts Are 0

Platform discussions Special workflows & use cases

BiancaT (Bianca Taylor) December 19, 2023, 3:56am 2

Hey Megan!

Would you be happy to share a screenshot of the columns in your board that are included in your formula? This way we can see the column type and test this on our end?

Topic		Replies	Views
Formular that can handle null values in multiple cell Platform discussions columns , formula	4	647	October 20, 2023
Add Percentage to divide by 0 error in formula column Special workflows & use cases formula	4	1950	December 15, 2022
Formula not showing 0 when one column is 0 results Platform discussions columns , formula , numbers	3	155	July 4, 2024
Removing ! (One of the Parameters is Invalid) In Formula Column Special workflows & use cases formula , question	0	14	February 27, 2025
Formula Help - Blank Causing Error: #value Special workflows & use cases formula	2	294	March 26, 2024

Calculate Percentage, or Leave Blank if Both Column Counts Are 0

Become part of our community groups

Can't find what you're looking for?

Can't find
what you need?

Calculate Percentage, or Leave Blank if Both Column Counts Are 0

Related topics

Become part of our community groups

Can't find what you're looking for?

Can't findwhat you need?

Can't find
what you need?