how to use isnull in expression

[#1]

Hi,

how to use isnull in expression?

[CELAMBARASAN]

IsNull(expr )

Returns -1 (true) if expr returns NULL, otherwise 0 (false).

Use IsNull(FieldName) will return true if it is null

[ashfaq_haseeb]

What are you trying to achieve.

Can you post your application

You can use like this

If(RowNo() = 0 or IsNull(RowNo()),Sum(Sales)

regards

ASHFAQ

[#4]

In set analysis How to write isnull

eg.I want to use isnull for profitCent,But How to use in this expression.

num(sum({<PODate = {'>=$(=Date(MonthStart(min(CalenderDate)))) <=$(=Date(max(CalenderDate)))'} >} Amt))

[amit_saini]

Amol,

Below are few examples:

1. IF(ISNULL(ItemName)=0, ItemName, '001' ) AS ItemName

2.If( Len(Trim(Field))=0 or Isnull(Field) , this, that) as FieldName

3. =If( if(Year<>2013,avg([Act % of Rev.]),(Sum([Act. Scrap $])/sum([Act Revenue])))<>0,

     if(Year<>2013,avg([Act % of Rev.]),(Sum([Act. Scrap $])/sum([Act Revenue]))),

     null()

)

Thanks,

AS

[ashfaq_haseeb]

Hi

Considering profitCent is valid field.

Try like below

num(sum({<PODate = {'>=$(=Date(MonthStart(min(CalenderDate)))) <=$(=Date(max(CalenderDate)))'},profitCent={''}>} Amt))

Regards

ASHFAQ

[#7]

How to use isnull in given example

[ashfaq_haseeb]

No Attachment

regards

ASHFAQ

[anbu1984]

Try

num(sum({<PODate = {'>=$(=Date(MonthStart(min(CalenderDate)))) <=$(=Date(max(CalenderDate)))'},

Amt={'=Len(Trim(profitCent))=0'}>} Amt))

Or

num(sum({<PODate = {'>=$(=Date(MonthStart(min(CalenderDate)))) <=$(=Date(max(CalenderDate)))'},

Amt={'=NullCount(profitCent)>0'}>} Amt))