472,334 Members | 1,921 Online

Totalling calculation results in Discoverer

5
I have created a calculation in a Discoverer worksheet and am trying to produce a subtotal of the results-however, Discoverer keeps on failing . As I am new to the system is there something additional that I should be doing in order to create this total?

Thanks
Sep 3 '07 #1
11 4165
amitpatel66
2,367 Expert 2GB
What I assume from yur POST is that U r not able to compute SUB-Results from the TOTAL:

In that case why dont you try computing the SUB-TOTALS in the Work sheet itself (using GROUP BY clause in the Query) and then use that column in your Work Book.
Sep 3 '07 #2
gric
5
Thanks for your reply but as I'm so new to the system,I'm not sure what you mean.

The calcultions That I'm using are:

Calculation4:

CASE WHEN Positions.Actual Headcount = 0 then 1 ELSE Positions.Actual Headcount END

This is to avoid a divide by zero in the following:

Calculation7:

Organisation Profile.Postion Fte/Calculation4

When then try to produce a subtotal on Calculation7, the worksheet fails.

Is there a way around this.?
Thanks.
Sep 7 '07 #3
amitpatel66
2,367 Expert 2GB
Thanks for your reply but as I'm so new to the system,I'm not sure what you mean.

The calcultions That I'm using are:

Calculation4:

CASE WHEN Positions.Actual Headcount = 0 then 1 ELSE Positions.Actual Headcount END

This is to avoid a divide by zero in the following:

Calculation7:

Organisation Profile.Postion Fte/Calculation4

When then try to produce a subtotal on Calculation7, the worksheet fails.

Is there a way around this.?
Thanks.
Check for calculation examples here
Sep 7 '07 #4
amitpatel66
2,367 Expert 2GB
Thanks for your reply but as I'm so new to the system,I'm not sure what you mean.

The calcultions That I'm using are:

Calculation4:

CASE WHEN Positions.Actual Headcount = 0 then 1 ELSE Positions.Actual Headcount END

This is to avoid a divide by zero in the following:

Calculation7:

Organisation Profile.Postion Fte/Calculation4

When then try to produce a subtotal on Calculation7, the worksheet fails.

Is there a way around this.?
Thanks.
Please post the error that the worksheet displays?
Sep 7 '07 #5
amitpatel66
2,367 Expert 2GB
Please post the error that the worksheet displays?
Why dont you combine the two calculations in to one and just use one calculation:

Something Like:

CASE WHEN <col_nam> > 0 THEN <colnam> /<col_nam> ELSE <colnam>/1 END
Sep 7 '07 #6
gric
5
The error message that I get whenever I try to total Calculation7is:

"No data is shown because an error occurred while running the query"
-not very informative I'm afraid.

Cheers
Sep 7 '07 #7
amitpatel66
2,367 Expert 2GB
The error message that I get whenever I try to total Calculation7is:

"No data is shown because an error occurred while running the query"
-not very informative I'm afraid.

Cheers

Do POST back after testing for single calculation.
Sep 7 '07 #8
gric
5
The calculation worked fine but the worksheet failed when I introduced a sum operation on the calculation.
Thanks
Sep 7 '07 #9
amitpatel66
2,367 Expert 2GB
The calculation worked fine but the worksheet failed when I introduced a sum operation on the calculation.
Thanks
U are trying to create one more calculation that calculates SUM (previous calculation) ??

Pleas POST yur CALCULATION CODE for my reference
Sep 8 '07 #10
gric
5
Hi,

Thanks for spending your time over this. I created the following as a calculation

(Calculation7). I then used Calculation7 in a SUM calculation. By itself, Calculation7 worked fine but when quoted in a SUM calculation the Worksheet failed.

CASE WHEN Positions.Actual Headcount > 0 THEN Organisation Profile.Positions Fte/Positions. Actual Headcount ELSE Organisation Profile.Positions Fte/1 END

Regards
Graham
Sep 10 '07 #11
amitpatel66
2,367 Expert 2GB
Hi,

Thanks for spending your time over this. I created the following as a calculation

(Calculation7). I then used Calculation7 in a SUM calculation. By itself, Calculation7 worked fine but when quoted in a SUM calculation the Worksheet failed.

CASE WHEN Positions.Actual Headcount > 0 THEN Organisation Profile.Positions Fte/Positions. Actual Headcount ELSE Organisation Profile.Positions Fte/1 END

Regards
Graham
I think you cannot use one calculation in to another as you had the same problem before also. That is why i asked you to combine the two in to one.
Now why dont you try computing the SUM in the same calculation itself.
Sep 10 '07 #12