How to write this in set analysis?

[jim_chan]

hi guys,

I have a formula here, can anyone help me to change to set analysis?

If((not (IsNull(grp_cust_id) and IsNull(trip_end_date))),count(trip_id)) -  it works in IF statement by the way.

Rgds,

Jim

[trdandamudi]

May be as below:

Count({<Len(Trim(grp_cust_id))>{'0'},Len(Trim(trip_end_date)={'0'})>}   trip_id)

OR

Count({<grp_cust_id={'*'},Len(Trim(trip_end_date)={'0'})>}   trip_id)

[Anonymous]

Would create flags in script for both null scenarios then use the flags in the set analysis

set analysis something like count({<[grp_cust_id_flag]={'Y'},[trip_end_date_flag]={'Y'}>}trip_id)

[jim_chan]

Hello Thirumala,

there modifier expression error.

Rgds,

Jim

[jim_chan]

ok.. will try it out .

[sunny_talwar · Accepted solution]

May be this:

Count({<grp_cust_id)) = {'*'}> + <trip_end_date = {'*'}>} trip_id)

[trdandamudi]

Give a try on the below:

Count({<Len(Trim(grp_cust_id))={'>0'},Len(Trim(trip_end_date)={'0'})>}   trip_id)

OR

Count({<grp_cust_id={'*'},Len(Trim(trip_end_date)={'0'})>}   trip_id)

[trdandamudi]

Sunny,

grp_cust_id should be not null and trp_end_date should be null, I think you need to modify the expression..

[jim_chan]

this works. -

Count({<grp_cust_id = {'*'}> + <trip_end_date = {'*'}>} trip_id)

[sunny_talwar]

I think Not is over-arching both the fields grp_cust_id and trp_end_date

If((not (IsNull(grp_cust_id) and IsNull(trip_end_date))),count(trip_id))