## NaN formula

Frequent Contributor

## NaN formula

Hi,

Please see attachment for my inquiry.

Appreciate the help on this.

Regards,

4 ACCEPTED SOLUTIONS

Accepted Solutions
Certified Master Anaplanner

## Re: NaN formula

HI,

Try to put If condition in your target line item. Please see below screen shot attached.

Here I made number formatted , zero format Blank.

Let me know if you have any concerns. I hope this solves your problem.

Thanks,

Kavin.

Regards,
Kavin.
Certified Master Anaplanner

## Re: NaN formula

Hi,

Create a line item(Number Format), then Use the below logic,

Logic,

IF ISBLANK(TEXT(Rank)) THEN 0 ELSE Rank

Rank is my source line item in my example, Rank final is FInal Value.

In your example, Forzen TAT is Source.

if you dont want to see "0" in final value, change the zero format to Blank..

~Vignesh

Certified Master Anaplanner

## Re: NaN formula

Hi, I would recommend to use following formula for Frozen TAT:

FROZEN TAT = if isblank('FROZEN START DATE') or isblank('UNFREEZE DATE') then 0 else'UNFREEZE DATE' -  'FROZEN START DATE'

FROZEN TAT number format should be "blank" for zero formats

Certified Master Anaplanner

## Re: NaN formula

Hi,

Just to share with you an easy way that one of my colleagues had to check NaN values and transform it in zero.

if abs(value(Text line item)) >= 0 then value(Text line item) else 0

Hope it helps!

Ciao

Alex

5 REPLIES 5
Certified Master Anaplanner

## Re: NaN formula

HI,

Try to put If condition in your target line item. Please see below screen shot attached.

Here I made number formatted , zero format Blank.

Let me know if you have any concerns. I hope this solves your problem.

Thanks,

Kavin.

Regards,
Kavin.
Certified Master Anaplanner

## Re: NaN formula

Hi,

Create a line item(Number Format), then Use the below logic,

Logic,

IF ISBLANK(TEXT(Rank)) THEN 0 ELSE Rank

Rank is my source line item in my example, Rank final is FInal Value.

In your example, Forzen TAT is Source.

if you dont want to see "0" in final value, change the zero format to Blank..

~Vignesh

Frequent Contributor

## Re: NaN formula

Hi Vignesh,

Thank you for the reply, I will try to re-create it using your approach.

Regards,

Certified Master Anaplanner

## Re: NaN formula

Hi, I would recommend to use following formula for Frozen TAT:

FROZEN TAT = if isblank('FROZEN START DATE') or isblank('UNFREEZE DATE') then 0 else'UNFREEZE DATE' -  'FROZEN START DATE'

FROZEN TAT number format should be "blank" for zero formats

Certified Master Anaplanner

## Re: NaN formula

Hi,

Just to share with you an easy way that one of my colleagues had to check NaN values and transform it in zero.

if abs(value(Text line item)) >= 0 then value(Text line item) else 0

Hope it helps!

Ciao

Alex