Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Count({<grp_cust_id)) = {'*'}> + <trip_end_date = {'*'}>} trip_id)
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)
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)
Hello Thirumala,
there modifier expression error.
Rgds,
Jim
ok.. will try it out .
May be this:
Count({<grp_cust_id)) = {'*'}> + <trip_end_date = {'*'}>} trip_id)
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)
Sunny,
grp_cust_id should be not null and trp_end_date should be null, I think you need to modify the expression..
this works. -
Count({<grp_cust_id = {'*'}> + <trip_end_date = {'*'}>} trip_id)
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))