Dealing %

[Joaquin_Lazaro]

Hello:

I have an expression to calculate the % of a total, I need a second expression that accumulate he previous % ... but I'm not able to write it.

Please, could you help me?

This is the expression

NUM( 100 *

      SUM( Sales )       

    / SUM( TOTAL Sales)        

    , $(NumberFormat2Dec), DecimalSep, ThousandSep)

And this is the table that i can't get

Which expression i need write in column 2 ??

Thank you very much,

Joaquín

[tresesco]

rangesum (above(sum(x),0,2))

//'x' should be replaced by the label of the first column/Column(1).

[Joaquin_Lazaro]

Thanks tresesco

I've written rangesum (above(sum(x),0,2)) in second expression and tagged column 1 as x

The value of column2 is 0 for all the rows

[er_mohit]

Try this

rangesum(above(sum(Sales),0,rowno(total)))

[Joaquin_Lazaro]

[tresesco]

Sorry, Sum() should not be there. try:

rangesum (above(x,0,RowNo(Total)))

RowNo(Total) - would be required to sum up till the end.

[Joaquin_Lazaro]

Hi:

= rangesum(above(X,0,2))

= rangesum(above('X',0,2))

In both cases I get 0 for all the rows ... the first is marked as wrong expression it editor because is not a field name (X is the tag of the expression

[Joaquin_Lazaro]

Thanks ER.Mohit:

Column 2 values are 0 too

[Joaquin_Lazaro · Accepted solution]

Hi guys:

The correct expression for column2 is:

= NUM( 100 *

    RangeSum(Above(SUM( Sales ), 0, RowNo()))

     / SUM( TOTAL Sales )

, $(NumberFormat2Dec), DecimalSep, ThousandSep)

and it works under two conditions: a) The chart must be a straight table and b) Only with one dimension

Thanks again