Percentage Calculation Really HARD ( help from Genies needed)

[cognosfighter]

Hi all ...I am in  a hard time with a percentage calculation!

I have a crosstab with:

ROWS:
A ( a calculation account 1 + account2 )

B (  one member = "account3")


C (  CASE END structure sentence "Case when Account long name starts with 131...")


Columns:

June 2008

Jul 2008

measure: net debit balance

I need the percentage calculation for the rows... for jun 2008 and july

how can I do that???

[juancruz]

No brave cognos guru? please???
help here :(

[sgotike]

I am not sure what you are looking for. Can you show a sample what the data might look like in tabular form something like


column1       column2        jun2008  july2008
                                     
value            value            value        value (is this the percentage? at what level?)

[NaviGator]

What do you mean by percentage ? should it be something like (A/B * 100) ?

Could you please write down the mathematical expression for you calculation so that we can understand what is the problem.

[juancruz]

Here we go again:
I have a crosstab with:

ROWS:
A ( a calculation account 1 + account2 )

B (  one member = "account3")


C (  CASE END structure sentence "Case when Account long name starts with 131...")

D >> >SHOULD BE A TOTAL row (sum)


Columns:

June 2008

Jul 2008

The columns  I need is the column % June 2008 ( amount of row A / row D for June 2008 %)

I think the thing is that someting is getting messy when you mix a data item, a case structure and  personalized calculation.

can you help now?

[juancruz]

no "good soul" there please?

[Rajaggopal]

Try this and see...
percentage ( Total (A) / Total (A for June 2008) )

Im not sure if this solves your problem... my Cognos connection is kinda down now so cant test it...

[juancruz]

njot working no problem...

[juancruz]

I made this calculation using the value tuple formulaes
use parentesis in all sections of the formula to achieve it

best wishes