Set Analysis and Fields (and eventually wildmatch!)

[Dayna]

Hello All,

I'm sure this is an easy one, but I'm struggling! What I want to do is a set analysis expression where if EXPR1 = 1 and pt_part_type = ps_part_type, sum some results.

Eventually, I'd like to put something like a wildmatch in, so it looks at the left 3 characters of pt_part_type and compares it with the 3 left characters of ps_part_type, but baby steps..

I thought it would be something like this:

sum({$<tr_type = {'ISS-WO'},EXPR1 = {'1'},pt_part_type=ps_sub_part_type >} value)

But it only brings back a result when I've select the ps_sub_part_type that it would be applicable to... Anyone have any ideas?

Many thanks for any help you can provide!

Kind Regards,

Dayna

[swuehl]

Hi,

to assign also the possible values, try the p() function:

sum({$<tr_type = {'ISS-WO'},EXPR1 = {'1'},pt_part_type= p(ps_sub_part_type) >} value)

Regards,

Stefan

[Dayna]

I don't think it's worked, I might be wrong but to test it I'm summing a value that should only have one (where part type = r25).

Please see attached..

Kind Regards,

Dayna

[swuehl · Accepted solution]

Ah, you want to limit ps_sub_part_type, then?

sum({$<tr_type = {'ISS-WO'},EXPR1 = {'1'},ps_sub_part_type= p(pt_part_type) >} value)

[Dayna]

Thank you!!