Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i have a list of customer and value. I want find a customer and her min value. I have attached a photo with the my problem.
Thanks.
The simplest solution I can think of would look like this:
Dim:
Customer
Exp:
if(min(TOTAL Value)=min(Value),min(Value))
See this may be:
Expressions:
1) =FirstSortedValue(Customer, Aggr(Only(Value), Customer, Value))
2) =Min(Value)
Create a Straight Table
Dimension
No Dimension
Expression
1) Min(Value)
2) FirstSortedValue(Customer, Value)
Hi,
another solution could be an expression like this:
=Only({$<Value={"=Value=Min(TOTAL Value)"}>} Value)
hope this helps
regards
Marco
The simplest solution I can think of would look like this:
Dim:
Customer
Exp:
if(min(TOTAL Value)=min(Value),min(Value))
Hello, thank for the answer. This code works only if there only one value minium. For example there is only A = 10. But if there is A = 10 and B = 10, it write only A = 10.
How works this code: $<Value={"=Value=Min(TOTAL Value)"}>
Hi,
In straight table ,
Dimension:
=if(match(Customer ,'B'),Customer)
-SupressNull
Expression:
=Min(Value)
Thanks,
Hirish