Same object different values

building reports desktopintelligence
1

Hello everybody,
This is my new problem (see added screenshot):
You can see one section of the report with a table that works like this:

% Non Conformities = (Derogated + Rejected) / Total Deliveries
Filter = If > 5 And <% Non Conformities> > 5 Then 1 Else 0
Under filter you see the SUM of filter
Selected cell: if Sum() > 0 Then 1 Else 0

All these formulas work how I want them to work.
BUT:
The selected cell is a value to determine the table/section should be visible or not. But when I enter the last variable into the table/section hide formula it doesn’t work as intended. So I placed the SAME formula under the table. There you can see the values are different. And the hiding works with the values of the added cell.

How can this be solved ? What do I do wrong ? … ?

Thanks for your time,
Tom
sqi_report_problem.jpg

TCL (BOB member since 2008-09-01)

2

Hi there,

As you wrote : “under the table”. A formula has a different reaction under a section and under a table… hummm pretty hard for to express myself in english on this topic but I try (maybe you speak French cause you are from belgium :wink:

Well, you can’t obtain the same result cause the values into your formulas are on the row level (detail). differents values each row, so you have to agregate your formulas if you want a good result !

cheers

kenny :fr: (BOB member since 2007-01-02)

3

Go into design mode (as opposed to results mode) and make sure the value in the free cell is in the section.

Damocles :uk: (BOB member since 2006-10-05)

4

Thanks both for the replies !!

The extra field is in the right section.
So I think kenny’s approach will be the best. But I don’t know how I should addapt my formula. Or are you saying that it’s impossible to do what I want ?

PS: Sorry, my english is better than my french. But you can always try if you want. For me it’s better than nothing ! :slight_smile:

TCL (BOB member since 2008-09-01)

5

Ok So let’s continue in french monsieur :lol:

Well, have you tried to put an aggregate function as MIN, MAX, SUM… into the formula (I mean that one into the section area) ?

cheers
kenny

kenny :fr: (BOB member since 2007-01-02)

6

Ok , je vais essayé de m’expliquer en francais… :stuck_out_tongue:

I tried those aggregate functions but the result of the cell outside the table (that is equal to the value of the hide formula) still doesn’t match.

I’m going to try and start all over, wasted more than a week, but if no one can help me I’m going to try with less variables and more SQL.

BUT: reactions, suggestions or ideas are still always welcome !!

TCL (BOB member since 2008-09-01)