How 'bout simply formatting the number so that Empty cells have the value you wish?
I tried to format a cell to obtain a specific value when the content is empty.
1- If < then “non created” else → doesn’t work bacause mixes text and numeric values. 2- If < then -9999 else → empty cells stay empty.
3- I wanted to have a numeric value anywhere so instead of putting I put +0, hoping that empty cells will get the value 0 → empty cells stay empty.
And other trials such as “IsNull” function, … always leave my empty cells empty.
Has anybody an idea about how to fill empty cells ?
My crosstab looks like that (it’s really basic, but I want to introduce an alerter on quantity, based on creation date) :
I tried all of your solutions.
And I desperately keep my empty cells EMPTY, except when I format undefined cell as Thomas suggests. But formatting cells doesn’t change the actual content of it.
It should be pretty easy however :
My crosstab contains only sales per month per product :
Month
Product
When I have no sales for one product one month (–> empty cell), I would just like to transform it into a “0” value, to make treatment after (alerter based on creation date for instance, or even actual average i.e. including months where there is no sale). And it is not possible to make a test on #EMPTY value. IsNull function applies to Null values, not to NO value. Maybe BO could study a function “IsEmpty”. That would solve my problem, and probably help some other users too.
Anyway ideas are still welcome !