Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
May be this?
= Count({<days = {"<90"} >}ID)
OR
= Count(DISTINCT {<days = {"<90"} >}ID)
May be this?
= Count({<days = {"<90"} >}ID)
OR
= Count(DISTINCT {<days = {"<90"} >}ID)
May be this
Count(DISTINCT {<ID = {"=Sum(days) < 90"}>} ID)
Maybe this
Count({<days={"=$(<=90)"}>}ID) in set analysis.
If you need in script i think is easier
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
Can you give an example of what you are expecting?
= IF(and (Sum (month1, month2, month3) = 0; "Churn90"; if ((sum (month 1, month2) = 0; "Churn60"; "No Billing"
How could this variable be made?
Try this?
= IF( RangeSum(month1, month2, month3) = 0, "Churn90",
if( Rangesum(month1, month2) = 0, "Churn60", "No Billing"))
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.