YTD calculation

[#1]

Hi,

I have only year and month fields. and on selection of year and month, it should give me the addition of  consecutive months (january onwards, upto selected month/year)

For ex, on selecting 2014 March, i want sum of January2014 + february 2014 + march 2014 value.

How can it be done

Thanks.

[senpradip007]

Try like:

Sum({<Year={$(=Max(Year))}, Month={'<=$(=Max(Month))'}>} YourField)

[#3]

thanks, i have written the same expression. but it gives me only selected month/year value. and doesnt take the previous years in calculation.

[PrashantSangle]

Hi,

Try this,

Sum({<Year={"$(=Max(Year))"}, Month={"<=$(=Max(Month))"}>} YourField)

If possible can share your sample apps

Regards

[tresesco]

Hi,

This  sort of analysis majorly depends on data type(how you calculate them in the script...); specially date formats. Hence, request you to create a sample qvw and share.

[ashfaq_haseeb]

Hi,

Check this

YTQ, QTD, MTD and WTD

Regards

ASHFAQ

[#7]

how do  i post the qvw. i dont find any option to post it.

[senpradip007]

Click on Reply link, then click Use advanced editor and attach your sample qvw.

[#9]

i am using google chrome and find no option of advanced editor

[senpradip007]

I'm also using chrome as well. First click Reply link, then you will find Use advanced editor link.