Finding blank cells in a number line item

Options
IanHall2000
IanHall2000 Member, ALL USERS Posts: 3 New Contributor
in Planning & Modeling

I want to filter by a number line item to show just blank cells, but I cannot figure out how. I know the ISBLANK function is what I want to use, but it cannot be used on numbers. Is there a way to find blanks in a number formatted line item similar to the ISBLANK function?

Tagged:

Comments

  • Ivan_Lo_
    Ivan_Lo_ Member, ALL USERS, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

    Hi Ian,

    It sounds like your number line item display blank when it is zero. I think you need to change the formula to check if line item = 0.

     

    Cheers

  • IanHall2000
    IanHall2000 Member, ALL USERS Posts: 3 New Contributor

    I didn't realize that missing data would show up 0 for numbers so this is helpful, but it brought up another concern. I'm working with data that has both 0s that are actually 0 and other 0s that are defaulting to 0 because there was no data for that cell. The problem is that I want to differentiate between what is a true zero and what is a missing value for other calculations. Is there any way to set up another line item that can help distinguish between the two?

Categories