How to modify the below expression with out using month_n ?

[paulyeo11]

Hi All

How to modify the below expression with out using month_n ?

money(

Sum (if(Month_n=1, $(ColumnDim51)/$(Columndim89))/1000)

, $(vMoneyFormatK))

my next post i will attach my QV Doc

Paul

[paulyeo11]

Hi balraj

You are right , I don't want use month_n field to achieve same result.

Paul

Sent from my iPhone

[paulyeo11]

Hi Balraj

I have attach my actual QV doc in above post.

Paul

Sent from my iPhone

[Kushal_Chawda · Accepted solution]

Please select the Year =15 & use below expression

money(

(Sum ({<YearMonth={"$(=date(max(YearMonth),'YY MMM'))"}>} $(ColumnDim51))/sum({<YearMonth={"$(=date(max(YearMonth),'YY MMM'))"}>}$(Columndim89)))/1000

, $(vMoneyFormatK))

[paulyeo11]

Hi Kush

You got it right , Thank you very much.

money(

Sum(if(Year_n='1',$(ColumnDim51)/$(Columndim89)))/1000

, $(vMoneyFormatK))

Can you help me convert above expression with out using Year_n

Paul

[Kushal_Chawda]

I think

money(

(Sum({<year={"$(=year(today()))"}>}$(ColumnDim51))/sum({<year={"$(=year(today()))"}>}$(Columndim89)))/1000

, $(vMoneyFormatK))

[paulyeo11]

HI Sir

thank you , it work fine now

paul