set analysis variable construction

[drohm002]

Please see my data table below.  I want to create a variable that counts the number of 'ID's with days less than 90.  When I create the variable on my own, it gives me 6 as the answer, but really the answer should be 2 ID's.  I know I need to use the distinct function, but I just cant get the formula to work.  How can I accomplish this?  Thank you!

ID	days
1	5
1	5
1	5
2	20
2	20
2	20
3	100
3	100
3	100

[vishsaggi · Accepted solution]

May be this?

= Count({<days = {"<90"} >}ID)

OR

= Count(DISTINCT {<days = {"<90"} >}ID)

[sunny_talwar]

May be this

Count(DISTINCT {<ID = {"=Sum(days) < 90"}>} ID)

[eduardo_dimperio]

Maybe this

Count({<days={"=$(<=90)"}>}ID) in set analysis.

If you need in script i think is easier

[eru-alelo]

Hello, would it be possible to add more than one variable in this formula?

Because I have a base that needs to do the same type of scenario, but with more variables

[vishsaggi]

Can you give an example of what you are expecting?

[eru-alelo]

= IF(and (Sum (month1, month2, month3) = 0; "Churn90"; if ((sum (month 1, month2) = 0; "Churn60"; "No Billing"

How could this variable be made?

[eru-alelo]

[vishsaggi]

Try this?

= IF( RangeSum(month1, month2, month3) = 0, "Churn90",

  if( Rangesum(month1, month2) = 0, "Churn60", "No Billing"))

[eru-alelo]

It did not work, because I'm trying to apply this variable to the script.

Where I need the form to add (Jan; Feb; Mar; Abr) = 0; Scene 1; and so on.