P() Variable

male_carrasco — Fri, 28 Mar 2014 19:32:14 GMT

Hello,

I'm calculating the% of customers who bought the products A and B.

Example:

Count({1<Cliente = P({<Producto = {'A'} >})*P({<Producto = {'B'} >})>}Distinct Cliente)/ Count({1}DISTINCT Cliente)

I need to be a dynamic formula that calculates the% according to selection.

Thank you very much in advance.

Ale.

Re: P() Variable

whiteline — Sun, 30 Mar 2014 09:45:07 GMT

Hi.

Since you've used the {1} subset as the basis It's not clear how it should be dynamic.

Depending on your data model you can make it easier selecting the products directly:

Count({<Producto = {'A', 'B'}>} Distinct Cliente)/ Count(DISTINCT Cliente)