count customer that paid the minimum price

[idogridish2]

Hi,

how can i count in the layout the number of customer that paid the minimum price in each company?

i added a sample data/

my culc is wrong in the sample.

thanks.

[swuehl · Accepted solution]

With a selection in company, you can make it work using

=Count({$<Customer={"=PRICE=min(TOTAL PRICE)"}>}Customer)

But I guess you want have this expression consider the dimensional value of company, potentially for all companies.

Without a change to the script, you can use

=Sum( Aggr( If(PRICE = Min(TOTAL<Company> PRICE), 1), Company, Customer))

[sunilkumarqv]

Please try this

Count (Distinct aggr(Min(Total PRICE),Customer))

[tyagishaila]

Sum({$<PRICE={"$(=$(vMinPrice))"}>}Customer)

where variable

vMinPrice=Min(PRICE)