3 Replies Latest reply: Apr 19, 2013 9:38 AM by Nicolas Berthier RSS

    Sum if with ABOVE function

      Hi experts,

       

      I have a tiny issue haunting me!

       

      I have a table:

       

      Date               Load (already cumulated indata source)          Stock

      01/01/2013     10                                                                 20

      08/01/2013     10                                                                 20

      15/01/2013     15                                                                 20

      22/01/2013     15                                                                 20

      29/01/2013     20                                                                 20

       

      I have a chart with expression: Sum(Load) - Above(Sum(Load)) which shows weekly load:

       

      Date               Weekly load (already cumulated indata source)         

      01/01/2013     -                                                                

      08/01/2013     0                                                                

      15/01/2013     5                                                                

      22/01/2013     0                                                                

      29/01/2013     5

       

      I would like to add an expression in my chart which shows Stock only if weekly load is positive.

       

      I tried stuff like: Sum(If(Load - Above(Load)>0,Stock)) but it won't work. I think the keyword Above does not work in Sum if syntaxes.

      I also tried : Sum(If(Column(1)>0,Stock))  which Column(1) is my Weekly Load, but this will not do either.

       

      I tried with Set analysis syntaxes, but it does not work.

       

      Any ideas?

       

      Thanks experts!

       

      Nicolas