Show Data for the Last available date on a selected month.

[amithmurali]

Hi guys,

I have a Reports in which i have to show them the daily sales. by default it should show the latest dates data and it is showing but when i select some months the value is 0.

The equation i used is " sum({<NumMonth = {"$(vMaxNumMonth)"},Date = {$(=max(Date))}>}(MonthSale)) "

Where

           vMaxNumMonth = =max({<Year = {"$(vMaxYear)"}>}NumMonth)

It should show the Last available date on the selected Month.

[kaushiknsolanki]

Hi, 

Try this.

sum({<Date = {$(=max({<NumMonth = {"$(vMaxNumMonth)"}, Year = {"$(vMaxYear)"}>}Date))}>}(MonthSale))

Regards,

Kaushik Solanki

[amithmurali · Accepted solution]

I was having some decimal points in my dates fields . thats why qv was not able to give me the data. i used the floor function

floor(Date) as Date to remove the unwanted decimals.

then i was bale to get the desired data.