Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
May i know how to modify the expression to remove 2012 ? my expression is shown above ,
This?
=Sum({<IsInYTD={1}, Year={">$(=year(today())-2)"}> } sales)
Be careful about brackets.
Sum({<IsInYTD={'2013','2014}>}sales)
Try like:
Sum({<IsInYTD={1}, year -={2012}> sales)
Sum({<isinYTD={1},Year-={$(=Year(today())-2)}>} Sales)
it will be Dynamic. when you move next Year i.e 2015 and want data of 2014 and 2015
then it will auto make changes not need to right 2012 ,2013 to exclude.
hope this make sense
You can try
Sum({<IsInYTD={1}, year -={$(=MIN(Year))}> sales)
which means it will always disregard the earliest Year
Regards
Alan
Hi All
Thank you for your reply. but all not able to work. enclosed my QV doc.
It does work if you use
Sum({<IsInYTD={1}, year -={2012}>} sales)
as tresesco said above
Hi Alan
Can you send back the file to me , as i am using ver 9 , and still not able to see it work like your attach chart.
Paul
Use formula
=sum({$<Year ={">=2013"}>}IsInYTD)
I have implemented it in qv graph attached.
Paul,
Correct the curly brace and it will work in V9 also.
=Sum({<IsInYTD={1}, year -={2012}> } sales)