FIRSTNONBLANK for Numbers

Highlighted
Community Boss

FIRSTNONBLANK for Numbers

Can First Non Blank formula be used for numbers as mentioned. ArunManickam_0-1604284502692.png

 

When i try to, i get an error as follows,

ArunManickam_2-1604284611631.png

Let me know if you are able to successfuly use this formula for numbers.

 

Thanks

Arun

 

 

 

 

8 REPLIES 8
Highlighted
Master Anaplanner/Community Boss

Re: FIRSTNONBLANK for Numbers

@ArunManickam 

 

No way, as far as I know we can not use FNB on number formatted line items. It has to be removed from Anapedia as It will create confusion to many. Thanks for pointing this out.

 

Misbah

Highlighted
Master Anaplanner/Community Boss

Re: FIRSTNONBLANK for Numbers

@ArunManickam @Misbah 

 

Just a thought, did you try to change the summary status to None?  

Highlighted
Master Anaplanner/Community Boss

Re: FIRSTNONBLANK for Numbers

@rob_marshall 

 

Yes! and as expected It doesn't work.

Highlighted
Master Anaplanner/Community Boss

Re: FIRSTNONBLANK for Numbers

@Misbah 

 

Yep, just tested it out and you are correct, it does not work

Highlighted
Community Boss

Re: FIRSTNONBLANK for Numbers

@rob_marshall 

 

I tried with all summary options, it dint work.

 

Thanks

Arun

Highlighted
Master Anaplanner/Community Boss

Re: FIRSTNONBLANK for Numbers

@ArunManickam 

 

Correct

Highlighted
New Contributor

Re: FIRSTNONBLANK for Numbers

Hi,

Can you use the TEXT() within FNB?

Thanos
Highlighted
Master Anaplanner/Community Boss

Re: FIRSTNONBLANK for Numbers

@thanasis 

 

Yes, you can.