Max year max month

[rajni_batra]

hello m using this expression getting result for max year but max month only on selection..

i have to use it on dashboard so cant use selection there..

what should i use there tried only() also

sum({<[CAL.Fiscal Year]={$(=MaxFiscalYearGL)},[CAL.Fiscal Month]={"=$(=max([CAL.Fiscal Month Num]))"}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

[CELAMBARASAN]

Hi,

     What field you have used for Month and year Selection.

Celambarasan

[CELAMBARASAN]

Hi,

     Its little confusing.Can you explain little more clearly about your problem?

Celambarasan

[rajni_batra]

PFA.......

[CELAMBARASAN]

Hi,

     Sorry i'm using personal edition.I cann't open your attached QV file.

Celambarasan

[rajni_batra]

cal.fiscal year         for year

cal.fiscal month      for month

[jagan · Accepted solution]

Hi,

Try this expression

=sum({$<[Fiscal Year] = {$(MaxFiscalYear),$(=Max([Fiscal Year])-1)}, [Fiscal Month] = {"$(=Month(max([Link Date])))"}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

Let me know this is what you required.

Regards,

Jagan.

[rajni_batra]

no again giving results on selection only...

[rajni_batra]

but only asking for year selection not month this time ...

[jagan]

Hi Rajni,

You have no data for 2012 and 2013, that's why you are not getting the result.  When no year is selected, 2012 and 2013 are considered for chart. Because of no data the chart is not having data.

Regards,

Jagan.

[rajni_batra]

Done thank u!!!!!!!!!