Help in Set Analysis

[Anonymous]

Hi All,

Please any one can help me to write the below expression using  Set Analysis.

Count(Distinct If(FndCT_SDF_Ctgy = 'Same Day', PRE_AUDIT_ACCT_SCHDL))

/  (Count(Distinct PRE_AUDIT_ACCT_SCHDL) -

Count(Distinct If(FND_TAG = 'Funded' And IsNull(FndCT_SDF_Ctgy), PRE_AUDIT_ACCT_SCHDL)))

Thanks in Advance

Regards,

Ankit

[Miguel_Angel_Baeyens]

Hi Ankit,

The expression should look like the following

Count({< FndCT_SDF_Ctgy = {'Same Day'} >} Distinct PRE_AUDIT_ACCT_SCHDL)
/  (Count(Distinct PRE_AUDIT_ACCT_SCHDL) -
Count({< FND_TAG = {'Funded'}, FndCT_SDF_Ctgy = {"=Len(FndCT_SDF_Ctgy) = 0"} >} Distinct PRE_AUDIT_ACCT_SCHDL))

Check parentheses, I may have missed some.

Hope that helps.

Miguel

[Anonymous]

Thanks. Will check and revert back..

[vijay_iitkgp]

You can also use

Count(Distinct {$<FndCT_SDF_Ctgy={'Same Day'}>} PRE_AUDIT_ACCT_SCHDL)

/

Count(Distinct {$},PRE_AUDIT_ACCT_SCHDL)

-
Count(Distinct {$<FND_TAG = {'Funded'}, FndCT_SDF_Ctgy= {"=Isnull(FndCT_SDF_Ctgy)"}>} PRE_AUDIT_ACCT_SCHDL)

[Anonymous]

Hi Vipul, Miguel,

The isnull part is not working here, for both the Expressions which u guys have provided me.

Please if you can help me

[SunilChauhan]

In place of =Isnull(FndCT_SDF_Ctgy) use

$(=Isnull(FndCT_SDF_Ctgy))

Count({< FndCT_SDF_Ctgy = {'Same Day'} >} Distinct PRE_AUDIT_ACCT_SCHDL)
/  (Count(Distinct PRE_AUDIT_ACCT_SCHDL) -
Count({< FND_TAG = {'Funded'}, FndCT_SDF_Ctgy = {"$(=Len(FndCT_SDF_Ctgy)) = 0"} >} Distinct PRE_AUDIT_ACCT_SCHDL))

hope this helps

[Miguel_Angel_Baeyens]

Hi,

IsNull() has some reported issues in some hardware, hence the Len() = 0 (which means that the value has no length, so it's null). Is that what you are looking for? Can you post some sample data we can play with? Is FndCT_SDF_Ctgy a literal, a numeric value, is it an expression from another chart?

Regards.

Miguel

[#8]

Hi , Try to use this syntax. Count({< FndCT_SDF_Ctgy = {'Same Day'} >} Distinct PRE_AUDIT_ACCT_SCHDL) /  (Count(Distinct PRE_AUDIT_ACCT_SCHDL) - Count({< FND_TAG = {'Funded'}, FndCT_SDF_Ctgy = {} >} Distinct PRE_AUDIT_ACCT_SCHDL)) Hope this will help you. Good luck Regards, Nitin Jain

[Anonymous]

No even this is not working