how is formel in QV9

[#1]

Hi,

i have a formel

Sum({$<Month=, Year=> * 1<Date_MonthYear=
{"$(='<='&Only(Date_MonthYear)&'>'&Only(date(addmonths(Date_MonthYear,-12),'MMM-YYYY')))"} >}
Net_Value_Inv)

this work in Ver 8, but not in Ver 9.

What is not OK.

Thanks

[Anonymous]

Are you sure this worked??

I think there is a '<' missing for the set analysis

Sum({ < $<Month=, Year=> * 1<Date_MonthYear=

{"$(='<='&Only(Date_MonthYear)&'>'&Only(date(addmonths(Date_MonthYear,-12),'MMM-YYYY')))"} >}

Net_Value_Inv)

Think this should do the trick

[#3]

Hi Anita,

Thanks for your reply. Your formula is not work. Attached my qvw.

Do you have another Idea?

Thanks

[Anonymous]

Could you explain what you want to achieve with this expression?? Maybe there is another way for solving this...

P.S. I saw in the scripting side the term Directory; this should be removed 😉

regards Anita

[gandalfgray · Accepted solution]

Change your set expressions to this:

Sum({$<Month=, Year=, Date_MonthYear= {"$(='<='&Num(Only(Date_MonthYear))&' >'&Num(Only(date(addmonths(Date_MonthYear,-12),'MMM-YYYY'))))"} >} Net_Value_Inv)

hth/gg

edit: I think it works fine withouot the Only's also...

[gandalfgray]

As a sidenote I think you have an error in your Set MonthNames in the beginning of the load script.

It says May there, but I think you should have Mai instead?

/gg

[#7]

Hi,

Thank you very much. That work fine.

[#8]

Hi Anita.

Thanks