0 that appear as blanks

[Pamoa]

Hi,

I have a stock report that is using the following formula for a column called "count":

=Table.AddColumn(#"Add Gender_Cat","count", each if [stock] >= 1 then 1 else 0)

Instead of getting 0 i am gettings empty/blanks and then i get errors for it. For instance i have 6.241 errors ( all the rows with blanks)

If i try to replace the blanks by 0 it doesn't work.

 Thanks

[AlB · Accepted solution]

Hi @Pamoa 

1. Try changing the nulls fro zeroes (or an other value you need) before this step.

2. Otherwise account for the null in the formula for the custom column, for instance:

Table.AddColumn(#"Add Gender_Cat","count", each if [stock]=null then null else if [stock] >= 1 then 1 else 0)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers