problem with cumultaive values

[Anonymous]

for culmutaive values  ----i'm using a expresion

= rangesum(above(sum(sales)),o,rowno(total))

it working fine

but the the issue is we want to supress values where sum(sales) =0 because in cumulATIVE we cannot see this zero value because it's show  a previous values so the line chart is linear all over

how can i show my sUM(sales) =0 as 0 in cumulative..and once it's zero it can be suppresed

rangesum( if(sum(sales)=0,0,sum(sales)),0,RowNo(TOTAL))

but this didn't worked

Any suggestion plz

[#2]

Hi, if I understood you correctly, this is one way to do it :

Using the following example data :

LOAD * INLINE [

    F1, F2

    jan, 10

    feb, 20

    mar, 0

    apr, 30

    may, 40

    jun, 0

    jul, 50

];

Create a new straight table, add F1 as a dimension, then create the follwing 2 expressions :

Label : F2sum

Definition:

=rangesum( sum(F2),Above(F2sum))

It will create the cumulative column, then create the final expression :

=if(sum(F2) <> 0, F2sum) // to show null where sum is zero or

=if(sum(F2) <> 0, F2sum, 0) // to show zeroes

Then go to Presentation, select the F2sum column and hide it.

[Anonymous]

Thank for your reply

it is working for this expression

if

(sum([Actual Production])=0,0,rangesum(above(sum([Actual Production]),0,rowno(total

))))

Thanks again