

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Analysis Criteria to move with selection
Hi,
I have quite a simple question but can't seem to figure it out.
I have the following formula:
sum({< ProductName = {'CBL*'}>}BALANCE_QTY)
Because I only want to look at products starting with CBL, BUT if I select 1 product with CBL i still want it to move with the selection of that product. Writing the set analysis like this will always show the total of all products starting with CBL.
Hope you can provide me with an answer how to fix this.
Regards, Paul
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can try this:
=if(GetSelectedCount(ProductName)=0,
sum({< ProductName = {'CBL*'}>}BALANCE_QTY),
sum(BALANCE_QTY)
)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can try this:
=if(GetSelectedCount(ProductName)=0,
sum({< ProductName = {'CBL*'}>}BALANCE_QTY),
sum(BALANCE_QTY)
)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, didn't think about this work around

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm sure there is other solutions for this, in the meantime you can use it
good luck

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How about this?
Sum({<ProductName *= {'CBL*'}>} BALANCE_QTY)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi stalwar1, this will work when there is no selection on the product and also when there is one product selected ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was not 100% sure what Paul wanted, but this is what it will do
ProductName
CBL xyz
CBL abc
CBL ddd
JBL xyz
JBL abc
JBL ddd
When nothing is selected... the expression will show this
CBL xyz
CBL abc
CBL ddd
When CBL abc is selected.... the expression should show
CBL abc
When JBL abc is selected ... the expression will show nothing
Updated my post with images and sample

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it is replacing what I wrote above

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Your's is slightly different... if you select JBL abc... you will see JBL abc with your expression
For the other two cases... it will work the same way
But again, I don't know the requirement and your solution may very well be what is needed here

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sorrry, it is the fast food effect, I need a coffee ..

- « Previous Replies
-
- 1
- 2
- Next Replies »