Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i need to find the GJ_Woche who have the MAX and MIN value and put them in a textbox.
Regards
Stefan
For Max= FirstSortedValue(GJ_Woche, - Aggr(Sum(Erloes),GJ_Woche))
For Min=FirstSortedValue(GJ_Woche, Aggr(Sum(Erloes),GJ_Woche))
Thanks for you reply. If i filtered Listbox BU0 there is wrong value. Pls look at my jpg.
Is it that, you want the output remain same even after selection? If so then try using set like:
For Max= FirstSortedValue(GJ_Woche, - Aggr(Sum( {1}Erloes),GJ_Woche))
For Min=FirstSortedValue(GJ_Woche, Aggr(Sum({1} Erloes),GJ_Woche))
Fix your SUM(Erloes) by SUM({1}Erloes)
Yes i want it, but i need also min/max value from field (Sum(Erloes)
='Min in ' & FirstSortedValue(GJ_Woche, Aggr(sum({1}Erloes),GJ_Woche)) & ' ' & Min({1} RangeMax(Erloes))
Rest you can do yourself
Sorry, i get not the right value. With selected BU i have min of all rows. Can you pls look again?
Many, many thanks.