FIRSTNONBLANK for Numbers

[ArunManickam]

Can First Non Blank formula be used for numbers as mentioned. 

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

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

Thanks

Arun

[Misbah · Accepted solution]

@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

[rob_marshall]

@ArunManickam @Misbah 

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

[Misbah]

@rob_marshall 

Yes! and as expected It doesn't work.

[rob_marshall]

@Misbah 

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

[ArunManickam]

@rob_marshall 

I tried with all summary options, it dint work.

Thanks

Arun

[rob_marshall]

@ArunManickam 

Correct

[thanasis]

Hi,

Can you use the TEXT() within FNB?

Thanos

[rob_marshall]

@thanasis 

Yes, you can.