Last Entered Inventory Number

[vikas_nandanwar]

Hi,

I have data set including following Columns

Transaction Date, Data Week, Qty

I want last data week total Qty

Thanks,

Vikas

[mdmukramali]

Hi Vikas,

Anil solution is working fine,

have a look :

=Num(Sum({<MonthNum={'$(=Max(MonthNum))'},DataWeek={'$(=Max(DataWeek))'}>}Qty),'#,##0')

PFA,

Thanks,

Mukram.

[Anil_Babu_Samineni]

May be this?

Max({<[DataWeek] = {$(=Max([DataWeek]))}, MonthNum = {'$(=Max(MonthNum))'}>}Aggr(Sum({<[DataWeek] = {$(=Max([DataWeek]))}, MonthNum = {'$(=Max(MonthNum))'}>} Qty)))

This will return as below in text box? 90084.26

[Anil_Babu_Samineni]

My bad, Months and DateWeek should cover for Aggr()

Max({<[DataWeek] = {$(=Max([DataWeek]))}, MonthNum = {'$(=Max(MonthNum))'}>}Aggr(Sum({<[DataWeek] = {$(=Max([DataWeek]))}, MonthNum = {'$(=Max(MonthNum))'}>} Qty), Months, DataWeek))

[vikas_nandanwar]

Nope incorrect expression

[vikas_nandanwar]

I am attaching my data sheet and my App

Please check

[vikas_nandanwar]

I am attaching my data sheet and my App

Please check

[vikas_nandanwar]

Hi,

I am attaching my excel and app

[tresesco]

What is your expected output in the sample provided? For latest week's data try:

Sum({<[DataWeek] = {$(=Max({<[Transaction Date]={"$(=Max([Transaction Date]))"}>} DataWeek))}, Month = {$(=text(Month(Max([Transaction Date]))))}>} InvQty)

[vikas_nandanwar]

90084.26

[tresesco]

Try my above expression.