Fiscal Month based on Reporting Month

[vardhancse]

Hi,

Have one small requirement is that in my dashboard created one variable

vReportingmonth= Month(AddMonths(ReloadTime(),-1))

And added in document trigger, so that when ever I open the dashboard the month will be reporting month.

Now the requirement is that,

2 fields:

Monthname, FiscalMonth

Oct, 1

Nov, 2

Dec, 3

Jan, 4

Feb, 5

Mar, 6

Apr, 7

May, 8

Jun, 9

Jul, 10

Aug, 11

Sep, 12

based on the reporting month the field fiscalmonth should be shown always the fiscal month of the reportingmonth

[MK_QSL]

=Only({<Monthname = {"$(vReportingmonth)"}>}FiscalMonth)

[vardhancse]

Hi Manish,

thanks for your reply, the above condition is fine but I am looking for some thing different.

Like , the FiscalMonth should be static, like whatever month selection I am doing in the dashboard the fiscalmonth text object should show only the reporting month fiscal month.

Sorry if i am not clear in my initial question.

[MK_QSL]

=Only({1<Monthname = {"$(vReportingmonth)"}>}FiscalMonth)

[vardhancse]

Sorry Manish, In my text object when I applied the =Only({1<Monthname = {"$(vReportingmonth)"}>}FiscalMonth)

Its showing -

[MK_QSL]

Provide your sample app