Hi, I have created a Select function to filter a range of data, and it's working fine, but I need to divide this data by 10. I think it's simple, but I'm new on Klipfolio and having problems.
This is my formula:
This is my attempt:
Thanks.
Date
Votes
4 comments
-
Hi Jeferson,
If the select is returning the data you want then I think you want to count the result and then divide by 10. I am assuming the data returned is a list of values "Cadastor Completo". Since these values are not numeric, dividing by 10 does not make sense with out some other manipulation like a count.
If the count is what you want, you can change the SELECT to a COUNTIF and then divide by 10 as follows:
COUNTIF(AND(@deals list,C:C = "Cadastor Completo",@deals list,F:F<2013))/10
Let us know if you need more help with this or if I have misunderstood what you are looking for.
Keely
-
Hi Keely, thank you. It's working fine.
But if I need two or more filters, like: "Cadastro completo" or "Cadastro incompleto" or "Lead"... How can I do it?
-
Hi Jeferson,
For the case you describe I think IN is your best option
e.g. IN(@deals list,C:C, ARRAY("Cadastro completo","Cadastro incompleto","Lead"))
This replaces the part of your formula that was doing @deals list,C:C = "Cadastor Completo"
And the result will count any value in C:C that is one of the 3 values.
If instead you want a count for completo, incompleto and lead separately, e.g. in a chart or table, you can do something like
Column 1: deals list,C:C
Column 2: repeat(1,countall(deals list,C:C))/10
On column 1 go to properties and select add filter, in the filter pick the values you want to include in the table
On column 1 in properties check "group repeating labels"
Here is a document on using group, sort and filter actions for more details:
Keely
-
Hi Keely, thanks. It's working fine.
Please sign in to leave a comment.