Sum based on input boxes

[Anonymous]

I'm trying to create a model to give a sum per customer/SSN based on the value in input boxes. The reason why I'm trying input boxes is to see how the distribution changes, depending on the value I give in the range of 1-10.

I've created input boxes like varA, varB, varC etc.

The expression in my table is somewhat like

Sum(Aggr

((if,Flag1=1,VarA,0),

if(Flag2=1,VarB,0),

if(Flag3=1,Var3,0),

SSN))

All the Flags have either 1 or 0 as a value. My goal is to flag the SSNs which receives a sum of Vars >= 10.

So far this doesn't work, and I'm not sure if I'm able to really explain what I want. I haven't tried this approach with input boxes before, and I'm unsure if this is the best sollution. Google has so far not been my best friend, hoping some of you great minds can put me in the correct way of thinking/googling

[tresesco]

Not really if I understood. I would rather create one input box with one variable expecting value 1-10. That is one value at a time. Then use the variable in the expression like:

Sum({<YourField={">=$(yourVariable)"}>}SSN)

[parthesh]

can you provide qvw?