Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've attached an app, I really could use your help.
In that app, I have a table with StoreCode | ProductCode | MaxDate | SumQuantity.
I want to get the MaxDate for StoreCode regardless ProductCode.
Example:
when I have StoreCode = 2383 I want MaxDate = 2016-06-01 in every occurrence of StoreCode = 2383.
And in SumQuantity I whant the value of sum Quantity in that date.
Can you please help ?
Thanks in advance,
Sílvia
Try this:
Date(Max(TOTAL <StoreCode> {<RecordType = {"Stocks"}>} Date), 'YYYY-MM-DD')
Try this:
Date(Max(TOTAL <StoreCode> {<RecordType = {"Stocks"}>} Date), 'YYYY-MM-DD')
Once again I hit my head on a simple thing
Thanks a lot Sunny
Hi! I am looking at this post as I have the same problem. I want to understand what "{<RecordType = {"Stocks"}>}" in the above solution is doing, why we have to add this in the script (both as measure in a table and load script declaration on "'Stocks' AS [RecordType]".
Can anyone explain to me? I will adapt the solution to my app but want to understand why these extra elements are necessary.
Thank you!
Miyako
This approach didn't work out for my issue so please ignore my above question. I will post a new query to get your help. Thank you!