Help

[panipat1990]

Dear Team,

i stuck a requirement. i have data oct, nov dec month of different dates.

in oct month i have 24/10/2016,25/10/2016,26/10/2016,27/10/2016,28/10/2016

In Nov Month i have 26/11/2016,27/11/2016,28/11/2016,29/11/2016,30/11/2016

In Dec Month i have 11/12/2016,12/12/2016,13/12/2016,14/12/2016,15/12/2016,16/12/2016

For this i am sharing a qvd where all data exit with date.

i want to show only each month of maximum date wise Avl Value.If i see in oct month then it show only 28/10/2016 date regarding value

If i see in Nov month then it show 30/11/2016 date regarding value

If i see in Decmonth then it show 16/12/2016  date regarding value

How is it.Kindly Help Me For soliving this issue. Maximum date of each month

[sunny_talwar]

panipat1990‌ sir kindly provide your application and be less dependent on people here. I am helping out here because I want, not because I get paid

I hope you will understand

Best,

Sunny

[panipat1990]

Dear Sunny

Here i am attaching my app

[sunny_talwar]

Try this:

=Sum({$<Link_Date={$(=Chr(34) & Date(Max({$<Link_Date={"<$(=Date(MonthStart(Max(Link_Date)), 'DD/MM/YYYY'))"},[Fiscal Month]>} Link_Date),'DD/MM/YYYY') & Chr(34))}, [Fiscal Month]>} [Avl Value])

[panipat1990]

Kindly can you send me the app where you written this code.

[sunny_talwar]

Here you go (sorry I thought I attached it earlier)

[panipat1990]

If i created for Oct sep Aug Jul Jun May Apr

Then only in your code -1,-2,-3,-4,-5  Only i will have to do this

[sunny_talwar · Accepted solution]

Yes

=Sum({$<Link_Date={$(=Chr(34) & Date(Max({$<Link_Date={"<$(=Date(MonthStart(Max(Link_Date), -1), 'DD/MM/YYYY'))"},[Fiscal Month]>} Link_Date),'DD/MM/YYYY') & Chr(34))}, [Fiscal Month]>} [Avl Value])