NaN formula

Hi,

Please see attachment for my inquiry.

Appreciate the help on this.

Regards,

Nan_Inquiry_42400.docx

Tags

Modeling

Calculation Functions

Accepted answers

HI,

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

NaN formula.PNG

Here I made number formatted , zero format Blank.

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

Thanks,

Kavin.

Hi,

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

Logic,

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

Photo1.png.jpg

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. Photo1.png.jpg .

~Vignesh

nikolay_denisov

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

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

All comments

HI,

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

NaN formula.PNG

Here I made number formatted , zero format Blank.

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

Thanks,

Kavin.

Hi,

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

Logic,

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

Photo1.png.jpg

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. Photo1.png.jpg .

~Vignesh

Hi Vignesh,

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

Regards,

nikolay_denisov

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

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

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…