Value 0 is not being recognized

[Brijesh]

Hi community, 

I have a simple question regarding a calculated column, a 0 value is not being recognised. I have a calculated column (let's call it a column A), formatted whole number data-type. I'm creating another calculated column (let's call it column B) to find out a status based on value in column A. I'm using a simple if statment as per below;

Column B = IF('Table1'[Column A] = BLANK(),BLANK(),

IF('Table1'[Column A] <= 1,"Within SLA","Outside SLA"))

There are some blank values in column A, hence, in my condition I'm returnig blank for those but there are some 0 values in column A where it should return "Within SLA" INSTEAD it is returing blank!

I would appreciate your help on this issue.

Brijesh

[amitchandak · Accepted solution]

@Brijesh , Try like

Column B = IF( isblank('Table1'[Column A]) , BLANK(),
IF('Table1'[Column A] < 1,"Within SLA","Outside SLA"))

or

Column B = IF( isblank('Table1'[Column A]) , BLANK(),
IF('Table1'[Column A] <= 1,"Within SLA","Outside SLA"))

[amitchandak · Accepted solution]

@Brijesh , Try like

Column B = IF( isblank('Table1'[Column A]) , BLANK(),
IF('Table1'[Column A] < 1,"Within SLA","Outside SLA"))

or

Column B = IF( isblank('Table1'[Column A]) , BLANK(),
IF('Table1'[Column A] <= 1,"Within SLA","Outside SLA"))

[Brijesh]

Thanks Amit,

It worked like charm!! Do you know why it wasn't working when I was comparing blank value rather than ISBLANK function? I mean what's the difference between these two method?

[v-yiruan-msft · Accepted solution]

Hi @Brijesh ,

You can watch the following video to get a good understanding of difference with ISBLANK and BLANK():

BLANK,ISBLANK

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.