Totalling calculation results in Discoverer

[gric]

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

[amitpatel66]

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.

[gric]

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.

[amitpatel66]

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

[amitpatel66]

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?

[amitpatel66]

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

[gric]

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.

Thanks for the advice about combining the calculations-I'll have a go.

Cheers

[amitpatel66]

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.

Thanks for the advice about combining the calculations-I'll have a go.

Cheers

Do POST back after testing for single calculation.

[gric]

The calculation worked fine but the worksheet failed when I introduced a sum operation on the calculation.
Thanks

[amitpatel66]

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

[gric]

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

[amitpatel66]

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.