FirstSortedValue Expression issue

[techvarun]

Hi Experts,

The Below Expression is not evaluating the FirstSortedValue Statement.

=sum({1< [Source System] ={DLDAU}, [A Process Date]={"=FirstSortedValue({<[A Process Date]={'<=$(=Max([A Process Date]))'},_Day=,_Month=, _Year=>} TOTAL <[Source System]> [Process Date], -[Process Date])"}>}[B Job SuccessCNT])

Please help me to fix.

Thanks a lot in advance.

[tresesco]

A quick fix try:

[A Process Date]={'$(=FirstSortedValue({<[A Process Date]={'<=$(=Max([A Process Date]))'}_Day=,_Month=, _Year=>} TOTAL <[Source System]> [Process Date], -[Process Date]))'}

If this doesn't work, try to share a sample app.

[techvarun]

Thanks tresesco‌ for the prompt reply, However I am yet to get the desired result.

Kindly refer the attached app.

For the selection of Sep 18 currently i am getting the below result

Core Source System	date	Sum
123	2018-09-27	0
225	2018-09-28	12

And my expected result is

Core Source System	date	Sum
123	2018-09-27	12
225	2018-09-28	12

Where as the Sum for 123 should come from Sep 27.

Thanks a lot in advance

[techvarun]

Hi experts,

Any Inputs?

[tresesco · Accepted solution]

Try:

FirstSortedValue({<Core_Day=,Core_Month=, Core_Year>} Aggr( NODISTINCT Sum({<Core_Day=,Core_Month=, Core_Year>} [CoreB Job SuccessCNT]),[Core Source System],[Core Process Date]), -[Core Process Date])

[techvarun]

Thanks Tresesco

This works like a charm, I have another query what if i need to Display the Sum (24 in this case) in a text box?

Please help me with that

[tresesco]

=Sum({<Core_Day=,Core_Month=, Core_Year>}

               Aggr(

                         <AboveExpression>

                         ,[Core Source System]

                         )

          )