Exception Needed

[krobert1]

Need a calculation or general way to add an exception.

1) Basic filtering : data for "Cost Center #1"- "Cost Center #10#. However, I also want the data for "Cost Center #13" if "customer #1" is within the resuling
data.



Sent from my SM-G920P using Tapatalk

[krobert1]

Same challenge for this one- No replies as of yet. Figured I would show you how I am creating the filters in hope that you might be able to straighten out how I am improperly writing them? Missing Excel. . .

If ( [Customer#] = '1234' )
then ( [CostCenter] = '601' ) in [customertotals]
else ( [Costcenter] = '601' ) not in [customertotals]

TYIA

[bus_pass_man]

Yeah, you suspected right, that's not a valid filter expression. 

The basic filter expression syntax is something like this:

operand operator operand

The filter will operate based on the result and filter out stuff based on the expression.

For example:

Blah > 10 will filter out anything in Blah which is not greater than 10
Blah in ( 23, 34, 17) will filter out anything other than those three values.
Blah not in ( 23, 34, 17) will filter out those three values.




This is basically the same area which you've asked about here:

http://www.cognoise.com/index.php/topic,29693.0.html


I'm sad that you miss Excel.   You need to realize, however, that spreadsheets are not report authoring tools.  It's comparing apples and oranges.  You can do stuff with report studio that you can't with spreadsheets.  It's a poor workman who blames his tools.



And just a word of advice.  It might be me but there's something in the tone of your postings which makes it seem like you're doing us a favour by giving us the opportunity to solve your problems for you. I hope you don't write that way to your work colleagues because people might interpret it as coming from a right ar5eh0le. 

[krobert1]

Thanks for the advice. No, not trying to come off arrogant. I see these types of challenges as puzzles, and appreciate being challenged. Figured others on here might be the same way, but I can see where that is misinterpreted.

Was hoping to use this forum as a collaborative and judgement free site to assist me in improving my skills. It is not always easy adjusting to a new system, and may be even harder to admit so on a public forum.

Shame to be received with two insults.

Happy holidays to you and your family.

Sent from my SM-G920P using Tapatalk

[bdbits]

Guys, please keep the personal comments to yourselves.

As to the original question, there is not enough information presented. Remember that those reading your post have absolutely no idea about your data source or how the data is structured, much less the semantics of what the data means. Please read http://www.cognoise.com/index.php/topic,24030.0.html in particular item 1.

I would also suggest you read through the Report Studio user guide, available from the help menu. It will cover building basic reports and filters.