Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have 2 Set analysis calculation.
The first is: Num(Count({<PS_II={'P1'}, Vs= {">0"} >} Distinct FD_II) / Divisor,'#.##0') This Just Count People
Second: Sum Days of some special people: Num(Sum({<PS_II={'P1'}, Vs_II = {">0"} >}Vs_II) / Divisor,'#.##0') This Formula gives *90 Days*, 43 Days, 9 Days and so on.... when I do Clic on jun, may and jun
But I need to do clic only in one month.
For example: When I do clic (Field month) - Jun I would like to obtain = Count people with 90 Days (Mobile)
Resume: I need to get the final count of people who are 90 days old
Thanks!!
Hi Sunny thank you for your reply:
Num(Count({<PS_II = {'P1'}, Vs = {">0"}, FD_II = {"=(Sum({<PS_II = {'P1'}, Vs_II = {"">0""}>} Vs_II)/Divisor) >= 90"}>} Distinct FD_II) / Divisor),'#.##0')
if I remove the parentheses before my variable, it starts to work, now I have to see the form that it takes me 3 months, so that it counts me 90 days. Being stopped in the last month that I count the days of 3 months ago.
Num(Count({<PS_II = {'P1'}, Vs = {">0"}, FD_II = {"=(Sum({<PS_II = {'P1'}, Vs_II = {"">0""}>} Vs_II)/Divisor) >= 90"}>} Distinct FD_II) / Divisor,'#.##0')
may be this
num((Count({<PS_II={'P1'}, Vs= {">0"} ,FD_II={"=(Sum({<PS_II={'P1'}, Vs_II = {">0"} >}Vs_II) / Divisor)=90"}>} Distinct FD_II) / Divisor),'#.##0')
Slight change to make sure we either add escape sequence for the inner double quote
Num(Count({<PS_II = {'P1'}, Vs = {">0"}, FD_II = {"=(Sum({<PS_II = {'P1'}, Vs_II = {"">0""}>} Vs_II)/Divisor) = 90"}>} Distinct FD_II) / Divisor),'#.##0')
or use [] instead of "" for inner set
Num(Count({<PS_II = {'P1'}, Vs = {">0"}, FD_II = {"=(Sum({<PS_II = {'P1'}, Vs_II = {[>0]}>} Vs_II)/Divisor) = 90"}>} Distinct FD_II) / Divisor),'#.##0')
Also, may be it should be >= 90 days? I am not sure, but I have a feeling we check for >= 90 instead = 90
Num(Count({<PS_II = {'P1'}, Vs = {">0"}, FD_II = {"=(Sum({<PS_II = {'P1'}, Vs_II = {"">0""}>} Vs_II)/Divisor) >= 90"}>} Distinct FD_II) / Divisor),'#.##0')
Hi Sunny thank you for your reply:
Num(Count({<PS_II = {'P1'}, Vs = {">0"}, FD_II = {"=(Sum({<PS_II = {'P1'}, Vs_II = {"">0""}>} Vs_II)/Divisor) >= 90"}>} Distinct FD_II) / Divisor),'#.##0')
if I remove the parentheses before my variable, it starts to work, now I have to see the form that it takes me 3 months, so that it counts me 90 days. Being stopped in the last month that I count the days of 3 months ago.
Num(Count({<PS_II = {'P1'}, Vs = {">0"}, FD_II = {"=(Sum({<PS_II = {'P1'}, Vs_II = {"">0""}>} Vs_II)/Divisor) >= 90"}>} Distinct FD_II) / Divisor,'#.##0')
Which variable?
Sorry not variable.. Field (Divisor)