Solved

Define a cell as active despite having a zero value

Hi

Is it possible to define a cell as in use/active even when the result is zero?

I have a filter that distinguishes active cells so can I combine this with the formula so it returns a zero?

Thanks,

Best answer by Benoit

Hi,

In Pigment, zero and empty cells (blanks) are differentiated.

So ISDEFINED(metric), would return all non-blank cells (active) as true

ISBLANK(metric), would return all blank cells (inactive) as true

and if you wish to isolate active and zero cells only, you’d do an IF(metric = 0, true).

Hope it helps.

+13

Are you looking from something like ifdefined function? Here the the article for your reference.

Min Li

+18

@ChrisAHeathcote Can you try IFBLANK function (if it’s what you are looking for) ?

IFBLANK

+15

Hi,

In Pigment, zero and empty cells (blanks) are differentiated.

So ISDEFINED(metric), would return all non-blank cells (active) as true

ISBLANK(metric), would return all blank cells (inactive) as true

and if you wish to isolate active and zero cells only, you’d do an IF(metric = 0, true).

Hope it helps.

Benoit - Pigment wizard

Sign up