Ignore zero values on accumulated line in chart

[#1]

Dear community members

Has anyone an idea how I could ignore the datapints from the dark blue line ("Base planning CP"). The goal is to start at zero and directly connect the line to the next available amount. In my datamodel I only have dates + values on the desired datapoints.

Thanks for your help

Date	Value
31.01.2012	0
31.12.2013	51885
28.02.2014	164732
31.12.2016	20084

Nachricht geändert durch Michael Städtler

[sunny_talwar]

May be something like this:

If(YourExpression <> 0, YourExpression)

But you will need a additional if to check for the first 0. May be use the minimum date to allow that to be 0 and everything else becomes null().

[#3]

Thx for your post.

This is not working. The problem is the second expresion in this chart. Whenever it has a datapoint on a given date, it uses this date with value 0 also for the other expression.

Any other ideas?

[sunny_talwar]

May be able to offer better advice if I can have a sample to work with.

[#5]

! added the example with the desired line in my original post.

[miguelbraga]

@This?

[miguelbraga]

Just sets the static min in the axes as:

min(SUM({<KPIID = {20}>} VALUE))

Regards,

MB

[#8]

Thanks Miguel, but this is not the problem.

Please look at the example. The Line for "Base planning CP" should go straight from 0 to the first available data point (62'290,-). Now it goes parallel to the date axix and then to the first data point.

Thanks

[sunny_talwar · Accepted solution]

May be this:

If(Sum({<KPIID = {20}>} VALUE) = 0 and DATE <> Date(Min({<KPIID = {20}>}TOTAL DATE)), Null(), RangeSum(Above(Sum({<KPIID = {20}>} VALUE), 0, RowNo())))

[#10]

Works perfectly! Thank you sunindia!