topic Re: Max create date aggr in App Development

Max create date aggr

krmvacar — Tue, 02 Feb 2021 15:20:31 GMT

Hi guys ,

I want to

SUM({<(max([date]),[DOCNO]={'31'})>} [.GRANDTOTAL]) ,its not working.

Can you help me?

Re: Max create date aggr

GaryGiles — Tue, 02 Feb 2021 21:58:29 GMT

I think what you might be looking for is:

SUM({<[date]={'$(=max([date]))'},[DOCNO]={'31'}>} [.GRANDTOTAL])

Re: Max create date aggr

krmvacar — Wed, 03 Feb 2021 05:43:54 GMT

Thank you for answer. ı try But is not working. Answer give me zero:(

SUM({<[CREATEDAT]={'$(=max([CREATEDAT]))'},[DOCNO]={'31'}>} [GRANDTOTAL])

Re: Max create date aggr

MayilVahanan — Wed, 03 Feb 2021 06:39:53 GMT

Hi @krmvacar

Try like below

SUM({<[CREATEDAT]={"$(=Date(max([CREATEDAT]),'DD/MM/YYYY'))"},[DOCNO]={'31'}>} [GRANDTOTAL])

Change the DD/MM/YYYY date format to ur Createdat date format.

Re: Max create date aggr

krmvacar — Wed, 03 Feb 2021 07:20:14 GMT

Hİ MayilVahanan,

I try but not working.

My data;

Now ı want to show,

and ı want to result=304.

Thank you so much

Re: Max create date aggr

MayilVahanan — Wed, 03 Feb 2021 08:53:26 GMT

HI @krmvacar

So, you don't want max date for entire DocNo, its based on GrandTotal?
Your source has single record per date, docno & GrandTotal? or multiple singles available per date, docno?

Re: Max create date aggr

krmvacar — Wed, 03 Feb 2021 09:04:08 GMT

Hi @MayilVahanan

Your source has single record per date, docno & GrandTotal.

Re: Max create date aggr

MayilVahanan — Wed, 03 Feb 2021 09:23:25 GMT

Hi @krmvacar

If you have one record per combination, try like below

Temp:
LOAD * INLINE [
CREATEDATE, DOCNO, GRANDTOTAL
12.01.2021, 31, 148
15.01.2021, 31, 148
18.01.2021, 31, 156
];

Load *, if(GRANDTOTAL <> Peek('GRANDTOTAL'), 1, 0) as flag
Resident Temp Order By GRANDTOTAL, DOCNO, CREATEDATE desc;

DROP Table Temp;

EXIT SCRIPT;

Exp: SUM({<flag={1}>} [GRANDTOTAL])

Re: Max create date aggr

krmvacar — Wed, 03 Feb 2021 10:09:38 GMT

Thank you so much

its working 😀