topic How to use max yearmonth in Set Analysis in App Development

How to use max yearmonth in Set Analysis

maxloveiii — Mon, 20 Dec 2021 21:08:46 GMT

Hi, Experts

How can I use my first expression value (Max of nYearmonth of each Item) in set analysis of second expression. Item 31-KT-0-0007 result is correct but Item 31-KT-0-0006 isn't correct because max of nYearmonth is 202006 instead of 202004

Thanks in advance

Max

Re: How to use max yearmonth in Set Analysis

Steven_Haught — Mon, 03 Aug 2020 18:19:59 GMT

You need to have double quotes "" surrounding the set expression, instead of the single quotes, in the set expression. It acts like a search function with your $ expansion.

Re: How to use max yearmonth in Set Analysis

sunny_talwar — Mon, 03 Aug 2020 19:40:59 GMT

May be try this

FirstSortedValue(Aggr(Sum({<MonthEnd = {1}, Year, Month, Date>}BalQty), [Item Code], [nYearMonth]), -Aggr([nYearMonth], [Item Code], [nYearMonth]), 2)

Re: How to use max yearmonth in Set Analysis

maxloveiii — Fri, 07 Aug 2020 10:53:03 GMT

Thanks Sunny_talwar

It work great!