Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am this expression in my report to take only recent month last date sales only
it's work correct...
financial year, quarter it 's work perfect
if i click on month or date field it's going blank
dimension branch
Sum({<NumDate={'$(=floor(Num(max(MonthEnd(NumDate,-1)))))'}>}StockClosing_GROSSWEIGHT)
here in the above expression numdate nothing in script it floor(date) as numdate.
so even though i click any month or any date it needs to show only recent month monthend date stock only
actually we use to take only monthend's stock only get exact stock figures for closing stock.
Thanks in advance..
Remove '-1' from monthend() and try like:
Sum({<MonthField,DateField, NumDate={'$(=floor(MonthEnd(Max(NumDate))))'}>}StockClosing_GROSSWEIGHT)
Try:
Sum({<NumDate={'$(=floor(MonthEnd(Max(NumDate),-1)))'}>}StockClosing_GROSSWEIGHT)
i just used what you suggested but still it's showing blank tresesco
for me fin year and quarter it's showing correct this expression but month and date field selections showing blank...
Try with this corrected one:
Sum({<MonthField,DateField, NumDate={'$(=floor(MonthEnd(Max(NumDate),-1)))'}>}StockClosing_GROSSWEIGHT)
thanks it's working fine...
but another problem is there
if i click on feb month it's showing jan month enddate sales if i click on jan it's shoing dec month enddate sales.....
i requirement is if click on april since we didn't have last date in april it need to take march31 stock...
if i click on feb month since we have feb month last date so it need to take feb month last date sales only
thanks
Remove '-1' from monthend() and try like:
Sum({<MonthField,DateField, NumDate={'$(=floor(MonthEnd(Max(NumDate))))'}>}StockClosing_GROSSWEIGHT)
Thanks a lot for your help
i got idea and did like this
=if(GetSelectedCount(Month)>0 or GetSelectedCount(NumDate)>0,
Sum({<Month=,BILLDATE=,NumDate={'$(=floor(MonthEnd(Max(NumDate))))'}>}StockClosing_GROSSWEIGHT)/WeightFlag,
(sum({<NumDate={'$(=floor(Num(max(MonthEnd(NumDate,-1)))))'}>}StockClosing_GROSSWEIGHT))/WeightFlag)
it's working fine now....