Set Analysis - fix one selection, but not the other

[#1]

Hi there -

Here's what I'm trying to do. I have two list boxes, Networks and HH (household). I'd like the outcome, Total Time Spent, updated when users select different HHs, but not Networks.

To fix HH, i need to add 1 to the set analysis, but how do I include the two sets in one formula? I've attached a file.

[datanibbler]

Hi Carol,

try with the set-operator >P< - roughly like this

{1<field1 = P(field1)>}

That way, you disregard all user selections, optionally you can specify some fixed selections and those with the 'P' you leave to the user.

HTH

Best regards,

DataNibbler

[swuehl · Accepted solution]

You can disregard selections in Network using

Sum ( {<Network=>} [Time spent])