This content has been marked as final. Show 3 replies
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)
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.