Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
how to use isnull in expression?
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
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))
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
Hi
Considering profitCent is valid field.
Try like below
num(sum({<PODate = {'>=$(=Date(MonthStart(min(CalenderDate)))) <=$(=Date(max(CalenderDate)))'},profitCent={''}>} Amt))
Regards
ASHFAQ
How to use isnull in given example
No Attachment
regards
ASHFAQ
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))