Set Expression to Include and Exclude

[#1]

This was the original formula I was using in a bar chart until I was told we needed to trim down the displayed system names:

=(count({$<history_status_name={'Resubmitted'}>}history_update_date)/count(add_date))

So I tried some set analysis wizard and it came out with the following formula, but of course QV didn't like it.

=count({$<system_name-={'Capacity Tool Addition','CN Release - Test Wafer','New Development','Production'}>}(count({$<history_status_name={'Resubmitted'}>}history_update_date)/count(add_date)))

I need to exclude the 4 system names first, and then use history status names of "Resubmitted" in the calculations. Any suggestions?

[Gysbert_Wassenaar · Accepted solution]

I'm afraid I don't understand your requirements. Does this do what you want:

=count({$<system_name-={'Capacity Tool Addition','CN Release - Test Wafer','New Development','Production'},history_status_name={'Resubmitted'}>}history_update_date)/count(add_date)))

[#3]

Try This

=count({1-$<system_name={'Capacity Tool Addition','CN Release - Test Wafer','New Development','Production'},history_status_name={'Resubmitted'}>}history_update_date)/count(add_date)))

Regards,

Nirmal.

[#4]

Yes it does, Gysbert! I had to remove two parantheses at the end and it still underlined everything after:

=count({$<system_name-=

with a squiggly red line, but it was exactly what I needed. This will help tremendously with the rest of my expressoins as well.