Months wise value

[prma7799]

Dear All,

I am getting value on months wise when taking months as dimension but  when I am using below expression then its not showing values for max months

SUM({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear))}

,[Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear=$(=max(FiscalYear))}>}[Date]))"}

>}DivT)

Thanks

[bohravanraj]

let vMonthName = monthname(max(Date)); SUM({$}DivT) Try Above Code

[#3]

Please Try this Expression.

sum({$<Fiscalyear={$(=max(FiscalYear)},

Date={'>=MonthStart(max(PostingDate))<=MonthEnd(=max(PostingDate)')>}DivT)

[PrashantSangle · Accepted solution]

Hi,

try like

SUM({$<FinancialYear=,MonthName=,Quarter=,FiscalYear={$(=max(FiscalYear))}

,[Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear=$(=max(FiscalYear))}>}[Posting Date]))"}

>}DivT)

on which date field you want to compare ?? on Date or [Posting Date]???

Regards

[PrashantSangle]

Hi,

are doing any number formatting in first output.

value looks similar for max month i.e. Feb in first output and in second output.

only difference in number formatting.

Regards,