Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can disregard selections in Network using
Sum ( {<Network=>} [Time spent])
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
You can disregard selections in Network using
Sum ( {<Network=>} [Time spent])