topic Re: Firs stored value group by in App Development

Firs stored value group by

krmvacar — Fri, 05 Feb 2021 11:07:30 GMT

Hi ,

I have the following data. What I want to do here is to get the highest customer number from the ones that contain the customer ID in (1,2,3) and collect their price.

my expression;

sum(aggr(FirstSortedValue([TOTAL_PRICE],-Aggr(sum({<[OFFER_ID]={'01','02','03'}>}[OLPSALHEAD.DOCNUM]),[TOTAL_PRICE],))
,[Customer_Name]))

its not working 😞

Help please

Re: Firs stored value group by

agigliotti — Fri, 05 Feb 2021 11:45:15 GMT

Hi @krmvacar ,

It's not clear to me, what is your actual result and the expected one?

Re: Firs stored value group by

krmvacar — Tue, 09 Feb 2021 08:58:56 GMT

Hi @agigliotti ,

get the price of the person with the highest offer number

Re: Firs stored value group by

AshutoshBhumkar — Tue, 09 Feb 2021 10:08:37 GMT

Hi, Is the expected output 149000 ?

As Customer JOHN Contains Offer id 1,2,3 and max offer number 1347.

Re: Firs stored value group by

krmvacar — Wed, 10 Feb 2021 09:47:02 GMT

Hi @AshutoshBhumkar ,

Yes for JOHN 149000 and max offer number 1347 and for ABC max offer number 1455.

thank you so much