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.

• Keely Davison

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

• Jeferson Sousa

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?

• Keely Davison

Hi Jeferson,

For the case you describe I think IN is your best option

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:

https://support.klipfolio.com/hc/en-us/articles/222017088-Using-the-Filter-Group-Aggregate-and-Sort-actions-videos-

Keely

• Jeferson Sousa

Hi Keely, thanks. It's working fine.