null value in a table

[ecabanas]

Hi,

I have the following table:

FAMILIA	DES_SUB1	DES_SUB2	ITEMID	ITEMNAME	Stock	Consumption	Days	Stocking days
Total					6	0	19
01.ALIMENTACION	01.DESAYUNOS Y MERIENDAS	CACAO Y CREMAS	8410109001631	VALOR CHOCOLATE TAZA	6	0	19	-

The formula: "Stocking days" is a calculation: (Stock/Consumtion)*365 but in this case I have a stocking days "-". I tryied with this, but it does not work:

If( (Stock/Consumtion)*365 =null();0; (Stock/Consumtion)*365)

I would like to do, If it's "-" then '0'

Thank's

[kouroshkarimi · Accepted solution]

In the bottom left of the presentation tab you can set the replacement characters for null values. (Null Symbol & Missing Symbol). Try using isnull(value)=-1 instead of value=null() in your if statement.

[ecabanas]

thank's it works!!!!