Need to change a formula - please help 1

[PrograMist]

I am trying to pull a list of names from "machine" table of all the machines that do not have a certain application (channel) installed. As a result, I created a following formula in Select Expert:

{channel.url} <> &quot;

http://marimbalb.alltel.com:5282/ACI/ms03-026&quot;

and now the report is still pulling a list of ALL machines, listing ALL the other apps in the channel field but this one...

could you please help me to create a formular that would eliminate from the list every machine that doesn't have this application? (right now ALL of the machines are included, only this app is not listed for them, if they have it...)

Thank you...

 

[pgtek]

hi
they way your formula is formated
you will get all the machine that does not have that channel url as you have describe in your post

cheers

pgtek

 

[PrograMist]

but I do get the machines that have that channel, only it is not listed in the channel field -- other channels are listed for that machine...

and i need to ELIMINATE the machines that don't have that channel...

any suggestions?

 

[lbass]

I'm confused by your post--at first you seem to say you want a list of machines that DO NOT have a certain application installed and then later you say you want to ELIMINATE machines that do not have that channel. So, let's say the first is true--you are trying to generate a list of machines that do not have the application installed. The following should work:

First, group on {table.machineID}. Then create a formula {@channelinstalled}:

if {channel.URL} = &quot;

http://marimbalb.alltel.com:5282/ACI/ms03-026&quot;

then 1 else 0 //I can't seem to remove the semicolon after the &quot; in this post, but it doesn't belong in your formula

Then go to report->edit selection formula->GROUP and enter:

sum({@channelinstalled},{table.machineID}) = 0

This will return those machines without the channel installed. If you want a list of those who have it installed, then change the group selection formula to &quot;> 0&quot;.

-LB

 

[PrograMist]

lbass, thank you -- you post was very helpful -- I appreciate your good understanding of my confusing message and your help!