Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi,
Try this.
sum({<Date = {$(=max({<NumMonth = {"$(vMaxNumMonth)"}, Year = {"$(vMaxYear)"}>}Date))}>}(MonthSale))
Regards,
Kaushik Solanki
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.