calculation of range of products

[#1]

hi all,

I have following issue. Need to know the relatively range of products a customer has. I have a total range of products available (pricelist)

let's say 4000 units and a customer based product range, let's say 400 units .... so the result is 10%...

unfortunately I cannot find the funktion how to unlock the total available products from the selection I do, when I selcect a customer.

At the moment I always get 100% because both figures are linked to the selection criteria.

Hope you can help, thanx

Oliver

[israrkhan]

you have to count Total Products and to devide by Selected >>possible product for selected customer.

like so, =Count(Total Distinct ProductID) / Count(getfieldselections(Distinct ProductID))

[#3]

there must be something wrong in the last part... something is not working

==> / Count(getfieldselections(Distinct ProductID))

[#4]

sorry, I'm an absolutely beginner 🙂

[israrkhan]

what is your field name ,? is it ProductID , Replace it with your field..

or share the sample doc

[#6]

Count (Total DISTINCT Artikel)/ Count(GetFieldSelections(Distinct Artikel))

my field: Artikel

in the 2nd part of the formula is Distinct Artikel black colored.

[Gysbert_Wassenaar]

Try count(distinct Artikel)/count(distinct total Artikel)

[#8]

then I get always 100%

[Gysbert_Wassenaar · Accepted solution]

Maybe like this then: count(distinct Artikel)/count({1} distinct total Artikel)

[israrkhan]

Try This, that was not correct 

=count(all distinct  Artikel) / GetPossibleCount(Artikel)

try this in text box, select any customer, you will get the average