How to replace a blank cell with "0"

Question

Hi Everyone,

How can I replace a blank cell in a column by "0".

StatusTotal numbercompleted2pending1error 1 error 21

What is happening is:

DateCompletedpendingerror 1error 2Jan 721null1

CharlieS · Answer

@gagandeep_dhall wrote:But I figured out that I have to actually put "1" in all the blank fields for it to count that field 🙂

@gagandeep_dhall wrote:I tried using replace function, but it gives me an error that "tried to apply string operator to numeric value"

One way to achieve that is to apply a formula expression to that field that uses a simple IF statement like this:

IF IsEmpty([Total Number]) THEN 1
ELSE [Total Number] ENDIF

@gagandeep_dhall wrote:Do you know how can I add "%" to a set of values in columns?

Again, there's a few ways to go about this.

1. Convert the field to a string so the "%" character can be added with an expression like: [Total Number]+"%"

2. If you plan to output to a file like Excel, then you could use the Table tool in the Reporting section to create a layout which include a "%" suffix on the field before it is rendered to Excel.

Examples of all attached.

20210107-ReplaceNull2.yxmd

gagandeep_dhall · Answer

Hi @CharlieS  I was able to do that 🙂

Do you know how can I add "%" to a set of values in columns?

gagandeep_dhall · Answer

@CharlieS  to add to the above query, I tried using replace function, but it gives me an error that "tried to apply string operator to numeric value"