Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to write a sum() expresion that include excluded values. How can i do it?
when i write sum({1<>}), it returns sum of all of possible values. I want to include grayed values.
Hi
I think the answer to your question depends on the structure of your data model. It will be easier to suggest a fix and less testing for you if you could upload your model (or a sample if it large).
To upload, click the Use advanced editor link at the top right of the Reply form.
HTH
Jonathan
Hi
as Jonathan said it depends on model and field you are using for selection
So if you have a Calendar table you may use it to select 2013
you will have then Sales for 2013 (january only) and all forecasted monthes
best regards
Chris
Thanks christian, it's working
Hi,
see the following set analysis for included Year={$(=Max(Year))} and excluded Field -= {'value'}
=((Sum({<Year={$(=Max(Year))},Field -= {'value'}>}Amount))
Regards
Sunil
Hi Nicole Smith,
I have one requirement, here i attached one qvw file in that file
If i select for filter 1: Baby Clothes in Category Name, Aino Shoes from Product name, 2012 from Year and
for filter2:Baby Clothes in Category Name, Deuce Shirt from Product name, 2013 from Year
then i want out like this
2422 | 2/16/2012 | Baby Clothes | Aino Shoes | Halle Köln | Bob Park | 41 |
2422 | 2/16/2012 | Baby Clothes | Deuce Shirt | Halle Köln | Bob Park | 11 |
4665 | 1/21/2013 | Baby Clothes | Aino Shoes | La Moda d'il Futuri | Ricardo Gucci | 61 |
4665 | 1/21/2013 | Baby Clothes | Deuce Shirt | La Moda d'il Futuri | Ricardo Gucci | 12 |
But output is not showing like this, it is showing selections related 572 rows some thing
Give some suggestions to out from this situation
Thank you in advance
Sudhakar