Set Analysis query

[rahulhv1]

how can i write set analysis query for

  =if(isnull(FinanceRelease)=-1 and isnull(BusinessHeadRelease)=0 ,count(CapexKey))

here financerelease & businessheadrelease are date fields.

Pls. help me out for this.

[Anonymous]

Hi

Something like below,

=Count({$<FinanceRelease={"=isNull(FinanceRelease)"}, BusinessHeadRelease={"*"}>} CapexKey)

[#3]

Hi Rahul

    try this

count({<FinanceRelease={'isnull(FinanceRelease)=-1'},BusinessHeadRelease={'isnull(BusinessHeadRelease)=0'}>}CapexKey)

hope this will help you

[MK_QSL]

May be something like this..

Count({$<FinanceRelease = {"=LEN(TRIM(FinanceRelease))=0"},BusinessHeadRelease = {"=LEN(TRIM(BusinessHeadRelease))>0"}>}CapexKey)

[rahulhv1]

Sorry ,but its not giving any results

[rahulhv1]

Hi, Nirmal

Thanks for your reply, but sorry to say,its not working nor giving any errors

[MayilVahanan]

Hi

Try like this

=Count({<FinanceRelease-={"*"}, BusinessHeadRelease={"*"}>} CapexKey)

[perumal_41]

Hi

Try Like this

count(CapexKey={"=isnull(FinanceRelease)=-1 and isnull(BusinessHeadRelease)=0"}>}CapexKey))

[#9]

Hi Rahul,

probably the simplest way to do this is to create a null flag field in your script and use that within the set analysis.

In your script:

If(Isnull(FinanceRelease),'NULL') As FinanceRelease_NullFlag

Then in your expression:

=Count({$<FinanceRelease_NullFlag={'NULL'}, BusinessHeadRelease={'*'}>} CapexKey)

Hope that helps

Joe

[#10]

if(<FinanceRelease={'$(=null())'} ,BusinessHeadRelease={'$(=null())'}> count(CapexKey))